Skip to content

Commit 7a02ac2

Browse files
committed
doc: Fix statement about ON CONFLICT and deferrable constraints.
The description of deferrable constraints in create_table.sgml states that deferrable constraints cannot be used as conflict arbitrators in an INSERT with an ON CONFLICT DO UPDATE clause, but in fact this restriction applies to all ON CONFLICT clauses, not just those with DO UPDATE. Fix this, and while at it, change the word "arbitrators" to "arbiters", to match the terminology used elsewhere. Author: Dean Rasheed <dean.a.rasheed@gmail.com> Discussion: https://postgr.es/m/CAEZATCWsybvZP3ce8rGcVNx-QHuDOJZDz8y=p1SzqHwjRXyV4Q@mail.gmail.com Backpatch-through: 14
1 parent f281886 commit 7a02ac2

File tree

1 file changed

+2
-2
lines changed

1 file changed

+2
-2
lines changed

doc/src/sgml/ref/create_table.sgml

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1283,8 +1283,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
12831283
<literal>REFERENCES</literal> (foreign key) constraints accept this
12841284
clause. <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints are not
12851285
deferrable. Note that deferrable constraints cannot be used as
1286-
conflict arbitrators in an <command>INSERT</command> statement that
1287-
includes an <literal>ON CONFLICT DO UPDATE</literal> clause.
1286+
conflict arbiters in an <command>INSERT</command> statement that
1287+
includes an <literal>ON CONFLICT</literal> clause.
12881288
</para>
12891289
</listitem>
12901290
</varlistentry>

0 commit comments

Comments
 (0)