Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: problem with on conflict / do update using psql 14.4
From: Christophe Pettus <xof@xxxxxxxxxxxx>
Date: Sat, 24 Sep 2022 08:56:32 -0700
Cc: pgsql-general@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAMPa0rVHkdFe8_bog6Pt9Oa=7_LQkGDbR49sA_a043mE37G6dA@mail.gmail.com>
References: <CAMPa0rUQUqiVPQLdYSg7g8mrxyRzKf6cVjt2KXvJMnhvLcHbig@mail.gmail.com> <CAKE1AiaMhqwdpHuUCv+vx+1j7WYGne=kDyCFvLPMRATSNCN2vg@mail.gmail.com> <CAMPa0rUkyaFZnNZ-ZYQPz0S5rDEn8x7Onkg6=mG6szf__b0chw@mail.gmail.com> <65C8502E-7C7F-4F4D-B24B-708284C145F8@thebuild.com> <CAMPa0rX0bLAJGh14X=g+LL5VoX1_16-pbFPeVFmKJKyv=Kz3bA@mail.gmail.com> <FD75AF4B-D503-4B1A-BA13-BE5E4FA9CB7E@thebuild.com> <CAMPa0rVHkdFe8_bog6Pt9Oa=7_LQkGDbR49sA_a043mE37G6dA@mail.gmail.com>

> On Sep 24, 2022, at 08:49, Barry Kimelman <blkimelman@xxxxxxxxx> 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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: problem with on conflict / do update using psql 14.4
  - From: Barry Kimelman

References:
- problem with on conflict / do update using psql 14.4
  - From: Barry Kimelman
- Re: problem with on conflict / do update using psql 14.4
  - From: Steve Baldwin
- Re: problem with on conflict / do update using psql 14.4
  - From: Barry Kimelman
- Re: problem with on conflict / do update using psql 14.4
  - From: Christophe Pettus
- Re: problem with on conflict / do update using psql 14.4
  - From: Barry Kimelman
- Re: problem with on conflict / do update using psql 14.4
  - From: Christophe Pettus
- Re: problem with on conflict / do update using psql 14.4
  - From: Barry Kimelman

Prev by Date: Re: problem with on conflict / do update using psql 14.4
Next by Date: Re: problem with on conflict / do update using psql 14.4
Previous by thread: Re: problem with on conflict / do update using psql 14.4
Next by thread: Re: problem with on conflict / do update using psql 14.4
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]