🌐 AI搜索 & 代理 主页
Skip to content

Commit ae627d8

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 6c61c69 commit ae627d8

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
@@ -1379,8 +1379,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM
13791379
<literal>REFERENCES</literal> (foreign key) constraints accept this
13801380
clause. <literal>NOT NULL</literal> and <literal>CHECK</literal> constraints are not
13811381
deferrable. Note that deferrable constraints cannot be used as
1382-
conflict arbitrators in an <command>INSERT</command> statement that
1383-
includes an <literal>ON CONFLICT DO UPDATE</literal> clause.
1382+
conflict arbiters in an <command>INSERT</command> statement that
1383+
includes an <literal>ON CONFLICT</literal> clause.
13841384
</para>
13851385
</listitem>
13861386
</varlistentry>

0 commit comments

Comments
 (0)