ON CONFLICT DO SELECT

Edit
ID 6109
Title ON CONFLICT DO SELECT
CI (CFBot) Summary
Stats (from CFBot) Patch version: v26, Patch count: 2, First patch: +1681−356, All patches: +1677−367
Tags SQL Commands
Created 2025-10-07 12:49:28
Last modified 2026-02-12 10:19:17 (1 week ago)
Latest email 2026-02-12 10:22:41 (1 week ago)
Status
PG19-Final (2026-03-01 – 2026-03-31): Committed
PG19-4 (2026-01-01 – 2026-01-31): Moved to different CF
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 Dean Rasheed (deanr)
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-02-12 10:22:41 by Dean Rasheed <dean.a.rasheed at gmail.com>
Latest attachment (v26-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2026-02-11 14:54:55 from Viktor Holmberg <v at viktorh.net>
    Attachment (v26-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2026-02-11 14:54:55 from Viktor Holmberg <v at viktorh.net> (Patch: No)
    Attachment (v25-0001-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2026-02-11 11:33:55 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: No)
    Attachment (v24-0003-Add-support-for-INSERT-.-ON-CONFLICT-DO-SELECT.patch) at 2026-02-09 18:09:28 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: No)
    Attachment (v23-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE.patch) at 2026-02-04 12:52:10 from Viktor Holmberg <v at viktorh.net> (Patch: No)
    Attachment (v22-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE.patch) at 2026-01-28 20:33:21 from Viktor Holmberg <v at viktorh.net> (Patch: No)
    Attachment (v21-0001-Add-ON-CONFLICT-DO-SELECT-FOR-SHARE-UPDATE-misc-fix.no-cfbot) at 2026-01-24 02:18:49 from jian he <jian.universality at gmail.com> (Patch: Yes)
    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-02-12 10:19:17 Dean Rasheed (deanr) Closed in commitfest PG19-Final with status: Committed
2026-02-04 10:27:36 Dean Rasheed (deanr) Added deanr as committer
2026-02-04 06:28:45 Jian He (stayreal) New status: Ready for Committer
2026-02-01 00:00:09 CFbot Moved from CF PG19-4 to CF PG19-Final
2026-01-28 12:10:35 Andrei Krylosov (krylosov-aa) Removed krylosov-aa from reviewers
2026-01-28 12:10:32 Andrei Krylosov (krylosov-aa) Added krylosov-aa as reviewer
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