Horton

Re: ON CONFLICT DO SELECT (take 3)

Viktor Holmberg <v@viktorh.net>

View thread
From: Viktor Holmberg <v@viktorh.net>
To: Dean Rasheed <dean.a.rasheed@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2025-11-10T10:18:54Z
Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Add support for INSERT ... ON CONFLICT DO SELECT.

  2. doc: Fix statement about ON CONFLICT and deferrable constraints.

  3. Fix ON CONFLICT ON CONSTRAINT during REINDEX CONCURRENTLY

Ah, must’ve been that I added the previous thread for referene on the commitfest entry. Thanks for sorting that out.
Looking forward to your review!

/Viktor
On 10 Nov 2025 at 10:21 +0100, Dean Rasheed <dean.a.rasheed@gmail.com>, wrote:
> On Tue, 7 Oct 2025 at 12:57, Viktor Holmberg <v@viktorh.net> wrote:
> >
> > This patch implements ON CONFLICT DO SELECT.
> > I’ve kept the patches proposed there separate, in case any of the people involved back then would like to pick it up again.
> >
> > Grateful in advance to anyone who can help reviewing!
>
> Thanks for picking this up. I haven't looked at it yet, but I'm
> planning to do so.
>
> In the meantime, I noticed that the cfbot didn't pick up your latest
> patches, and is still running the v7 patches, presumably based on
> their names. So here they are as v8 (rebased, plus a couple of
> indentation fixes in 0003, but no other changes).
>
> Regards,
> Dean