Re: problem with on conflict / do update using psql 14.4

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Barry Kimelman <blkimelman(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: problem with on conflict / do update using psql 14.4
Date: 2022-09-24 15:56:32
Message-ID: 4C678705-D2B6-447D-979D-20A18871902B@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Sep 24, 2022, at 08:49, Barry Kimelman <blkimelman(at)gmail(dot)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 allow you to do change a row to resolve a conflict, and then insert it.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Barry Kimelman 2022-09-24 16:04:14 Re: problem with on conflict / do update using psql 14.4
Previous Message Barry Kimelman 2022-09-24 15:49:09 Re: problem with on conflict / do update using psql 14.4