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 /doc/src | |
| 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 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 3f139917790..b337f2ee555 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -594,6 +594,15 @@ 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> |