Skip to content

Commit f188bc5

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 52a9588 commit f188bc5

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
@@ -1245,8 +1245,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
12451245
<literal>REFERENCES</literal> (foreign key) constraints accept this
12461246
clause. <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints are not
12471247
deferrable. Note that deferrable constraints cannot be used as
1248-
conflict arbitrators in an <command>INSERT</command> statement that
1249-
includes an <literal>ON CONFLICT DO UPDATE</literal> clause.
1248+
conflict arbiters in an <command>INSERT</command> statement that
1249+
includes an <literal>ON CONFLICT</literal> clause.
12501250
</para>
12511251
</listitem>
12521252
</varlistentry>

0 commit comments

Comments
 (0)