Re: ON CONFLICT DO SELECT (take 3)

Viktor Holmberg <v@viktorh.net>

From: Viktor Holmberg <v@viktorh.net>

To: Dean Rasheed <dean.a.rasheed@gmail.com>, Marko Tiikkaja <marko@joh.to>

Cc: Andreas Karlsson <andreas@proxel.se>, pgsql-hackers@postgresql.org

Date: 2025-11-20T10:22:25Z

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
doc: Fix statement about ON CONFLICT and deferrable constraints.
- f188bc5145b5 15.16 landed
- 4c4fa53b9d2d 14.21 landed
- 8348004b54a7 16.12 landed
- 7a02ac28ab11 17.8 landed
- e9443a55265f 19 (unreleased) landed
- ae627d8a3cb0 18.2 landed
Fix ON CONFLICT ON CONSTRAINT during REINDEX CONCURRENTLY
- 2bc7e886fc1b 19 (unreleased) cited

On 20 Nov 2025 at 09:50 +0100, Marko Tiikkaja <marko@joh.to>, wrote:
> On Thu, Nov 20, 2025 at 10:50 AM Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> > On Thu, 20 Nov 2025 at 01:29, Andreas Karlsson <andreas@proxel.se> wrote:
> > >
> > > Yup! "My" patch was just Marko's patch rebased on PG17/PG18 and with
> > > support for new PG features added, more tests and a couple of bugs
> > > fixed. The original idea and huge parts of the patch are indeed Marko's.
> >
> > OK, got it. So author credit for this patch should go to Marko,
> > Andreas, and Viktor? In that order? And I should add the original
> > thread to the commit message.
>
> I think Andreas gets first author on this one.
>
> Thanks!
>
> .m
I don’t mind the author credit order, I just want to delete the
SELECT INSERT SELECT dances from my code. (in 2 years or
 however long it will take for PG19 to trickle down to heroku).
So all fine by me!
/Viktor