Re: problem with on conflict / do update using psql 14.4 - Mailing list pgsql-general

From Christophe Pettus
Subject Re: problem with on conflict / do update using psql 14.4
Date
Msg-id 4C678705-D2B6-447D-979D-20A18871902B@thebuild.com
Whole thread Raw
In response to Re: problem with on conflict / do update using psql 14.4  (Barry Kimelman <blkimelman@gmail.com>)
Responses Re: problem with on conflict / do update using psql 14.4
List pgsql-general

> On Sep 24, 2022, at 08:49, Barry Kimelman <blkimelman@gmail.com> wrote:
> I thought the whole point of ON CONFLICT DO UPDATE was so that you could modify the data so that it would be inserted

ON CONFLICT DO UPDATE allows you to modify the existing row that conflicted with the row being inserted, but it won't
allowyou to do change a row to resolve a conflict, and then insert it. 


pgsql-general by date:

Previous
From: Barry Kimelman
Date:
Subject: Re: problem with on conflict / do update using psql 14.4
Next
From: Barry Kimelman
Date:
Subject: Re: problem with on conflict / do update using psql 14.4