agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: kacperkuras@hotmail.com
Subject: E.6.3.2.1. Constraints
Date: Sat, 19 Sep 2026 14:49:55 +0000
Message-ID: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/18/release-18.html
Description:
Commit 086c84b23 changed what a foreign key with ON DELETE RESTRICT or ON
UPDATE RESTRICT raises when it refuses a change: SQLSTATE 23001
(restrict_violation) instead of 23503 (foreign_key_violation), and the
message now says "violates RESTRICT setting of foreign key constraint". The
PostgreSQL 18 release notes do not mention it.
Code that catches 23503 to report that a row is still referenced stops
matching RESTRICT keys after upgrading, while NO ACTION keys still raise
23503. The same notes list the change to the XML error codes (cd838e200), so
this one seems to belong there as well.
view thread (5+ messages) latest in thread
Message-ID: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org>
Permalink: ../178982939588.1243.6087398342138761960@wrigleys.postgresql.org/
Also on: postgresql.org/message-id/178982939588.1243.6087398342138761960@wrigleys.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, kacperkuras@hotmail.com
Subject: Re: E.6.3.2.1. Constraints
In-Reply-To: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox