8000 doc: mention that INSERT can block because of unique indexes · postgres/postgres@106ab85 · GitHub
[go: up one dir, main page]
Skip to content

Commit 106ab85

Browse files
bmomjianbmomjian
committed
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
1 parent 8db5026 commit 106ab85

File tree

1 file changed

+5
-0
lines changed

1 file changed

+5
-0
lines changed

‎doc/src/sgml/ref/insert.sgml

Lines changed: 5 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -75,6 +75,11 @@ INSERT INTO <replaceable class="parameter">table_name</replaceable> [ AS <replac
7575
</para>
7676

7777
<para>
78+
<command>INSERT</command> into tables that lack unique indexes will
79+
not be blocked by concurrent activity. Tables with unique indexes
80+
might block if concurrent sessions perform actions that lock or modify
81+
rows matching the unique index values being inserted; the details
82+
are covered in <xref linkend="index-unique-checks"/>.
7883
<literal>ON CONFLICT</literal> can be used to specify an alternative
7984
action to raising a unique constraint or exclusion constraint
8085
violation error. (See <xref linkend="sql-on-conflict"/> below.)

0 commit comments

Comments
 (0)
0