v12-0005-Revert-Doc-cover-index-CONCURRENTLY-causing-erro.patch
application/x-patch
Filename: v12-0005-Revert-Doc-cover-index-CONCURRENTLY-causing-erro.patch
Type: application/x-patch
Part: 2
Patch
Same data as JSON:
GET /api/v1/attachments/:id/patch
the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes.
API reference →
Format: format-patch
Series: patch v12-0005
Subject: Revert "Doc: cover index CONCURRENTLY causing errors in INSERT ... ON CONFLICT."
| File | + | − |
|---|---|---|
| doc/src/sgml/ref/insert.sgml | 0 | 9 |
| src/backend/optimizer/util/plancat.c | 0 | 5 |
From 5bacecbc5bed4f6cd0eb6827c5c4e3c14692678e Mon Sep 17 00:00:00 2001
From: Mikhail Nikalayeu <mihailnikalayeu@gmail.com>
Date: Sun, 9 Nov 2025 11:48:34 +0100
Subject: [PATCH v12 5/5] Revert "Doc: cover index CONCURRENTLY causing errors
in INSERT ... ON CONFLICT."
This reverts commit 8b18ed6dfbb8b3e4483801b513fea6b429140569.
---
doc/src/sgml/ref/insert.sgml | 9 ---------
src/backend/optimizer/util/plancat.c | 5 -----
2 files changed, 14 deletions(-)
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml
index 0598b8dea34..04962e39e12 100644
--- a/doc/src/sgml/ref/insert.sgml
+++ b/doc/src/sgml/ref/insert.sgml
@@ -594,15 +594,6 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac
</para>
</tip>
- <warning>
- <para>
- While <command>CREATE INDEX CONCURRENTLY</command> or <command>REINDEX
- CONCURRENTLY</command> is running on a unique index, <command>INSERT
- ... ON CONFLICT</command> statements on the same table may unexpectedly
- fail with a unique violation.
- </para>
- </warning>
-
</refsect2>
</refsect1>
diff --git a/src/backend/optimizer/util/plancat.c b/src/backend/optimizer/util/plancat.c
index ff416f0522c..02c732f8817 100644
--- a/src/backend/optimizer/util/plancat.c
+++ b/src/backend/optimizer/util/plancat.c
@@ -789,11 +789,6 @@ find_relation_notnullatts(PlannerInfo *root, Oid relid)
* the purposes of inference. If no opclass (or collation) is specified, then
* all matching indexes (that may or may not match the default in terms of
* each attribute opclass/collation) are used for inference.
- *
- * Note: during index CONCURRENTLY operations, different transactions may
- * reference different sets of arbiter indexes. This can lead to false unique
- * constraint violations that wouldn't occur during normal operations. For
- * more information, see insert.sgml.
*/
List *
infer_arbiter_indexes(PlannerInfo *root)
--
2.43.0