回复：searching for libpq5-14.1-42PGDG.rhel8.x86_64

It returned “Access Denied” when I access the archive repo. Did I miss sonething？ ​ Thanks. | | wangq...@126.com | | 邮箱：wangq...@126.com | 回复的原邮件 | 发件人 | Ron Johnson | | 日期 | 2024年08月12日 12:01 | | 收件人 | pgsql-general | | 抄送至 | | | 主题 | Re: Re: searching for libpq5-14.1-42PGDG.rhel

Re: Insert works but fails for merge

So it looks like the OP does not mind updating more than one row. If you want to keep it simple and not do a lot of casting, consider using a CTE to do a reverse-upsert and use a prepared statement. Prepare and cast once, and have your app send the raw uncasted strings many, many times: prepare fo

Re: Insert works but fails for merge

On 8/11/24 03:09, Alban Hertroys wrote: On 10 Aug 2024, at 22:23, yudhi s wrote: On Sat, Aug 10, 2024 at 8:22 PM Adrian Klaver wrote: MERGE INTO tab1 AS target USING (VALUES ('5efd4c91-ef93-4477-840c-a723ae212d99', 123, '2024-08-09T11:33:49.402585600Z','2024-08-09T11:33:49.402585600Z')) AS s

Re: Insert works but fails for merge

> On 10 Aug 2024, at 22:23, yudhi s wrote: > On Sat, Aug 10, 2024 at 8:22 PM Adrian Klaver > wrote: > > MERGE INTO tab1 AS target > > USING (VALUES ('5efd4c91-ef93-4477-840c-a723ae212d99', 123, > > '2024-08-09T11:33:49.402585600Z','2024-08-09T11:33:49.402585600Z')) AS > > source(id, mid,txn_