diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-07-14 15:17:19 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-07-14 15:17:19 -0400 |
| commit | 6959e971b35e7e6e10d61b95699cec7985d053b1 (patch) | |
| tree | bb1f8ba41e0f405cf38eaff0e1f7aee5edbde357 | |
| parent | 3e071b2cf584052b0799ebbc4d38ecfdb5bd701a (diff) | |
| download | postgresql-6959e971b35e7e6e10d61b95699cec7985d053b1.tar.gz postgresql-6959e971b35e7e6e10d61b95699cec7985d053b1.zip | |
doc: mention that INSERT can block because of unique indexes
Initial patch by David G. Johnston.
Reported-by: David G. Johnston
Discussion: https://postgr.es/m/CAKFQuwZpbdzceO41VE-xt1Xh8rWRRfgopTAK1wL9EhCo0Am-Sw@mail.gmail.com
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/ref/insert.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index a9af9959c08..29e92546ef4 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -75,6 +75,11 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac </para> <para> + <command>INSERT</command> into tables that lack unique indexes will + not be blocked by concurrent activity. Tables with unique indexes + might block if concurrent sessions perform actions that lock or modify + rows matching the unique index values being inserted; the details + are covered in <xref linkend="index-unique-checks"/>. <literal>ON CONFLICT</literal> can be used to specify an alternative action to raising a unique constraint or exclusion constraint violation error. (See <xref linkend="sql-on-conflict"/> below.) |