pgsql: doc: Fix statement about ON CONFLICT and deferrable constraints.

From: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: doc: Fix statement about ON CONFLICT and deferrable constraints.
Date: 2025-12-09 10:54:46
Message-ID: E1vSvMk-003bTI-1a@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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(dot)a(dot)rasheed(at)gmail(dot)com>
Discussion: https://postgr.es/m/CAEZATCWsybvZP3ce8rGcVNx-QHuDOJZDz8y=p1SzqHwjRXyV4Q@mail.gmail.com
Backpatch-through: 14

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/e9443a55265fbf3726f7ba4d961399b7dff3ea9f

Modified Files
--------------
doc/src/sgml/ref/create_table.sgml | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Dean Rasheed 2025-12-09 10:54:47 pgsql: doc: Fix statement about ON CONFLICT and deferrable constraints.
Previous Message Richard Guo 2025-12-09 08:10:40 pgsql: Fix distinctness check for queries with grouping sets