diff options
| author | Noah Misch <noah@leadboat.com> | 2025-11-03 12:57:09 -0800 |
|---|---|---|
| committer | Noah Misch <noah@leadboat.com> | 2025-11-03 12:57:09 -0800 |
| commit | 8b18ed6dfbb8b3e4483801b513fea6b429140569 (patch) | |
| tree | e8ffc844f673408e0b14f3f3afdb37be7acfadb7 /src/backend/optimizer/util/plancat.c | |
| parent | e7ccb247b38fff342c13aa7bdf61ce5ab45b2a85 (diff) | |
Doc: cover index CONCURRENTLY causing errors in INSERT ... ON CONFLICT.
Author: Mikhail Nikalayeu <mihailnikalayeu@gmail.com>
Reviewed-by: Noah Misch <noah@leadboat.com>
Discussion: https://postgr.es/m/CANtu0ojXmqjmEzp-=aJSxjsdE76iAsRgHBoK0QtYHimb_mEfsg@mail.gmail.com
Backpatch-through: 13
Diffstat (limited to 'src/backend/optimizer/util/plancat.c')
| -rw-r--r-- | src/backend/optimizer/util/plancat.c | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/backend/optimizer/util/plancat.c b/src/backend/optimizer/util/plancat.c index f4b7343dace..d950bd93002 100644 --- a/src/backend/optimizer/util/plancat.c +++ b/src/backend/optimizer/util/plancat.c @@ -789,6 +789,11 @@ 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) |