Re: ON CONFLICT DO SELECT (take 3)

Viktor Holmberg <v@viktorh.net>

From: Viktor Holmberg <v@viktorh.net>

To: pgsql-hackers@postgresql.org

Date: 2025-11-14T14:34:08Z

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 →

Add support for INSERT ... ON CONFLICT DO SELECT.
- 88327092ff06 19 (unreleased) landed

Attachments

v10-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch (application/octet-stream) patch v10-0001
v10-0002-Review-comments-for-ON-CONFLICT-DO-SELECT.patch (application/octet-stream) patch v10-0002
v10-0003-Remaning-fixes-for-ON-CONFLICT-DO-SELECT.patch (application/octet-stream) patch v10-0003

Here are some updates that needed to be done after the improvements to the RLS docs / tests in 7dc4fa & 2e8424.

> On 10 Nov 2025, at 11:18, Viktor Holmberg <v@viktorh.net> wrote:
>
> 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