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>, jian he
<jian.universality@gmail.com>
Cc: pgsql-hackers@postgresql.org, Marko Tiikkaja <marko@joh.to>,
Andreas Karlsson <andreas@proxel.se>
Date: 2025-11-24T10:39:32Z
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
Attachments
- v14-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch (application/octet-stream) patch v14-0001
- v14-0002-More-suggested-review-comments.patch (application/octet-stream) patch v14-0002
- v14-0003-extra-tests-for-ONCONFLICT_SELECT-ExecInitPartit.patch (application/octet-stream) patch v14-0003
- v14-0004-ON-CONFLCIT-DO-SELECT-More-review-fixes.patch (application/octet-stream) patch v14-0004
Got a complication warning in CI: error: ‘lockmode’ may be used uninitialized. Hopefully this fixes it.