ON CONFLICT DO SELECT

Edit
ID 6109
Title ON CONFLICT DO SELECT
CI (CFBot) Summary
Stats (from CFBot) Patch version: v21, Patch count: 1, First patch: +1937−325, All patches: +1937−325
Tags SQL Commands
Created 2025-10-07 12:49:28
Last modified 2025-12-09 12:30:11 (1 month ago)
Latest email 2026-01-23 20:10:00 (5 hours ago)
Status
PG19-4 (2026-01-01 – 2026-01-31): Needs review
PG19-3 (2025-11-01 – 2025-11-30): Moved to different CF
Target version 19
Authors Viktor Holmberg (rutchkiwi)
Reviewers Dean Rasheed (deanr), Jian He (stayreal)Become reviewer
Committer
Links
Emails
INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2
First at 2024-12-01 17:47:20 by Andreas Karlsson <andreas at proxel.se>
Latest at 2025-10-07 12:01:20 by Viktor Holmberg <v at viktorh.net>
Latest attachment (v7-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-03-31 15:33:13 from Dean Rasheed <dean.a.rasheed at gmail.com>
    Attachment (v7-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-03-31 15:33:13 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-03-05 02:32:57 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v5-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-03-04 09:24:07 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v4-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2024-12-17 10:45:52 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v3-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2024-12-03 08:52:43 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
    Attachment (v2-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2024-12-01 17:47:20 from Andreas Karlsson <andreas at proxel.se> (Patch: Yes)
ON CONFLICT DO SELECT (take 3)
First at 2025-10-07 11:56:46 by Viktor Holmberg <v at viktorh.net>
Latest at 2026-01-23 20:10:00 by Viktor Holmberg <v at viktorh.net>
Latest attachment (v21-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE.patch) at 2026-01-23 20:10:00 from Viktor Holmberg <v at viktorh.net>
    Attachment (v21-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE.patch) at 2026-01-23 20:10:00 from Viktor Holmberg <v at viktorh.net> (Patch: No)
    Attachment (v20-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE.patch) at 2026-01-21 20:05:18 from Viktor Holmberg <v at viktorh.net> (Patch: No)
    Attachment (v19-0001-ON-CONFLICT-DO-SELECT-tests-on-updatable_view.no-cfbot) at 2026-01-19 03:47:08 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v19-0001-ON-CONFLICT-DO-SELECT.patch) at 2025-12-16 15:14:06 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v18-0001-ON-CONFLICT-DO-SELECT.patch) at 2025-11-28 22:02:30 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v17-0001-rowsecurity-tests-for-ON-CONFLICT-DO-SELECT-F.no-cfbot) at 2025-11-28 08:42:50 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v17-0001-ON-CONFLICT-DO-SELECT.patch) at 2025-11-25 13:24:17 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v16-0002-ON-CONFLICT-DO-SELECT-misc-fix.patch) at 2025-11-25 08:33:17 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2025-11-24 15:23:17 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v14-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2025-11-24 10:39:32 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v13-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2025-11-23 20:34:11 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
    Attachment (v12-0001-regress-tests-for-ONCONFLICT_SELECT-ExecInitP.no-cfbot) at 2025-11-20 06:11:27 from jian he <jian.universality at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2025-11-19 14:08:14 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-11-17 22:06:59 from "v at viktorh.net" <v at viktorh.net> (Patch: Yes)
    Attachment (v8-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-11-10 09:21:29 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: Yes)
    Attachment (0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-10-07 11:56:46 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
Re: ON CONFLICT DO SELECT (take 3)
First at 2025-11-14 14:34:08 by Viktor Holmberg <v at viktorh.net>
Latest at 2025-11-15 11:11:38 by jian he <jian.universality at gmail.com>
Latest attachment (v10-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-11-14 14:34:08 from Viktor Holmberg <v at viktorh.net>
    Attachment (v10-0001-Add-support-for-ON-CONFLICT-DO-SELECT-FOR.patch) at 2025-11-14 14:34:08 from Viktor Holmberg <v at viktorh.net> (Patch: Yes)
History
When Who What
2026-01-17 13:55:48 Jian He (stayreal) Added stayreal as reviewer
2025-12-09 12:30:11 Viktor Holmberg (rutchkiwi) Moved from CF PG19-3 to CF PG19-4
2025-11-14 16:09:44 Viktor Holmberg (rutchkiwi) Attached mail thread 5fca222d-62ae-4a2f-9fcb-0eca56277094@Spark
2025-11-10 09:01:12 Dean Rasheed (deanr) Added deanr as reviewer
2025-10-25 20:28:13 Viktor Holmberg (rutchkiwi) Attached mail thread 2b5db2e6-8ece-44d0-9890-f256fdca9f7e@proxel.se
2025-10-13 19:27:28 Viktor Holmberg (rutchkiwi) Changed tags to
2025-10-07 12:53:13 Viktor Holmberg (rutchkiwi) Changed tags to My First Patch
2025-10-07 12:49:28 Viktor Holmberg (rutchkiwi) Attached mail thread d631b406-13b7-433e-8c0b-c6040c4b4663@Spark
2025-10-07 12:49:28 Viktor Holmberg (rutchkiwi) Created patch record
Edit