Re: ON CONFLICT DO SELECT (take 3)

Marko Tiikkaja <marko@joh.to>

From: Marko Tiikkaja <marko@joh.to>

To: Dean Rasheed <dean.a.rasheed@gmail.com>

Cc: Andreas Karlsson <andreas@proxel.se>, Viktor Holmberg <v@viktorh.net>, pgsql-hackers@postgresql.org

Date: 2025-11-20T08:50:41Z

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 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