Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY

Edit
ID 5160
Title Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
CI (CFBot) Summary
Stats (from CFBot) Patch version: v12, Patch count: 5, First patch: +1319−2, All patches: +1525−64
Topic Bug Fixes
Tags Bugfix
Created 2024-08-07 09:35:03
Last modified 2025-11-10 18:59:22 (1 week ago)
Latest email 2025-11-09 11:20:11 (1 week ago)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version stable
Authors Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
Reviewers Become reviewer
Committer Álvaro Herrera (alvherre)
Links
Emails
Issues with ON CONFLICT UPDATE and REINDEX CONCURRENTLY
First at 2024-06-11 11:00:00 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest at 2025-11-09 11:20:11 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest attachment (v12-0002-Modify-the-infer_arbiter_indexes-function-to-con.patch) at 2025-11-09 11:20:11 from Mihail Nikalayeu <mihailnikalayeu at gmail.com>
    Attachment (v12-0002-Modify-the-infer_arbiter_indexes-function-to-con.patch) at 2025-11-09 11:20:11 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Specs-to-reproduce-the-issues-with-CREATE-INDEX-.patch) at 2025-11-03 20:41:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (doc-concurrently-on-conflict-v2nm.patch) at 2025-11-02 23:21:05 from Noah Misch <noah at leadboat.com> (Patch: Yes)
    Attachment (nocfbot-v1-0001-doc-Document-potential-failure-scenarios-for-conc.patch) at 2025-10-28 01:19:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Modify-the-infer_arbiter_indexes-function-to-con.patch) at 2025-10-20 19:27:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v9-0004-Modify-the-ExecInitPartitionInfo-function-to-cons.patch) at 2025-05-18 15:16:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v8-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch) at 2025-02-20 12:19:50 from Міхаіл Нікалаеў <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Specs-top-reproduce-the-issues-with-CREATE-INDEX.patch) at 2025-01-18 12:59:35 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v6-0003-Modify-the-infer_arbiter_indexes-function-to-also.patch) at 2025-01-13 21:58:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v5-0004-Modify-the-ExecInitPartitionInfo-function-to-cons.patch) at 2024-11-28 21:29:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v4-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch) at 2024-11-14 23:38:37 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Modify-the-infer_arbiter_indexes-function-to-cons.patch) at 2024-08-24 15:52:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v2-0001-specs-to-reproduce-issues-with-CREATE-INDEX-REIND.patch) at 2024-08-16 10:22:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-spec-to-reproduce-issue-with-REINDEX-CONCURRENTLY.patch) at 2024-08-07 09:30:44 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (test_cic_dic.patch) at 2024-06-24 07:06:21 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (better_test_error_report_in_case_of_invalid_index_used_as_arbiter_test_for_issue_with_upse.patch) at 2024-06-17 17:00:51 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (upsert_issue.patch) at 2024-06-14 13:30:55 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-test-for-issue-with-upsert-fail.patch) at 2024-06-11 11:00:00 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2025-11-09 11:21:39 Mihail Nikalayeu (mihailnikalayeu) From Noah Misch <noah@leadboat.com>
at 2025-11-03 22:52:05		 Issue documented
History
When Who What
2025-11-10 18:59:22 Álvaro Herrera (alvherre) Added alvherre as committer
2025-11-09 11:42:29 CFbot Patch does not need rebase anymore
2025-11-09 11:21:39 Mihail Nikalayeu (mihailnikalayeu) Added annotation "Issue documented" to 20251103225205.a4.nmisch@google.com
2025-11-06 07:16:25 CFbot Patch needs rebase
2025-09-04 14:18:38 Mihail Nikalayeu (mihailnikalayeu) Changed targetversion to stable
2025-09-04 14:18:15 Mihail Nikalayeu (mihailnikalayeu) Moved from CF PG19-1 to CF PG19-3
2025-09-04 14:18:12 Mihail Nikalayeu (mihailnikalayeu) Changed targetversion to 19
2025-06-23 08:48:28 Mihail Nikalayeu (mihailnikalayeu) Changed authors to Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
2025-06-23 08:48:09 Mihail Nikalayeu (mihailnikalayeu) Changed tags to Bugfix
2025-04-20 19:44:53 Mihail Nikalayeu (mihailnikalayeu) Closed in commitfest 2025-03 with status: Moved to next CF
2025-02-20 12:31:50 CFbot Patch does not need rebase anymore
2025-02-18 04:08:38 CFbot Patch needs rebase
2025-02-03 17:00:26 Michail Nikolaev (nkey) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-10 07:08:45 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-05 09:27:19 Andrey Borodin (x4m) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-24 14:02:32 Michail Nikolaev (nkey) Changed authors to Michail Nikolaev (nkey)
2024-08-07 09:35:13 Michail Nikolaev (nkey) Changed targetversion to stable
2024-08-07 09:35:03 Michail Nikolaev (nkey) Attached mail thread CANtu0ojXmqjmEzp-=aJSxjsdE76iAsRgHBoK0QtYHimb_mEfsg@mail.gmail.com
2024-08-07 09:35:03 Michail Nikolaev (nkey) Created patch record
Edit