Skip to content

Commit 4c4fa53

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 4896955 commit 4c4fa53

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
@@ -1224,8 +1224,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
12241224
<literal>REFERENCES</literal> (foreign key) constraints accept this
12251225
clause. <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints are not
12261226
deferrable. Note that deferrable constraints cannot be used as
1227-
conflict arbitrators in an <command>INSERT</command> statement that
1228-
includes an <literal>ON CONFLICT DO UPDATE</literal> clause.
1227+
conflict arbiters in an <command>INSERT</command> statement that
1228+
includes an <literal>ON CONFLICT</literal> clause.
12291229
</para>
12301230
</listitem>
12311231
</varlistentry>

0 commit comments

Comments
 (0)