From 758479213d574d6e2fbbdfee5328edef3d60da61 Mon Sep 17 00:00:00 2001 From: Álvaro Herrera Date: Tue, 2 Dec 2025 16:47:18 +0100 Subject: Remove doc and code comments about ON CONFLICT deficiencies They have been fixed, so we don't need this text anymore. This reverts commit 8b18ed6dfbb8. Author: Mihail Nikalayeu Discussion: https://postgr.es/m/CADzfLwWo+FV9WSeOah9F1r=4haa6eay1hNvYYy_WfziJeK+aLQ@mail.gmail.com --- 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 table_name [ AS - - - While CREATE INDEX CONCURRENTLY or REINDEX - CONCURRENTLY is running on a unique index, INSERT - ... ON CONFLICT statements on the same table may unexpectedly - fail with a unique violation. - - - diff --git a/src/backend/optimizer/util/plancat.c b/src/backend/optimizer/util/plancat.c index 4367f107e9c..07f92fac239 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) -- cgit v1.2.3