Message-ID: <f1828bd03077c2cbde82acc220925cfa968aad4e.camel@cybertec.at>
Subject: Re: E.6.3.2.1. Constraints
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Bruce Momjian <bruce@momjian.us>, kacperkuras@hotmail.com,
	pgsql-docs@lists.postgresql.org
Date: Tue, 22 Sep 2026 07:51:15 +0200
In-Reply-To: <arGAwYKNjCQGpHUh@momjian.us>
References: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org>
	 <arGAwYKNjCQGpHUh@momjian.us>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.60.2 (3.60.2-2.fc44) 
MIME-Version: 1.0
Archived-At: 
 <https://www.postgresql.org/message-id/f1828bd03077c2cbde82acc220925cfa968aad4e.camel%40cybertec.at>
Precedence: bulk

On Mon, 2026-09-21 at 15:08 -0400, Bruce Momjian wrote:
> On Sat, Sep 19, 2026 at 02:49:55PM +0000, PG Doc comments form wrote:
> > The following documentation comment has been logged on the website:
> >=20
> > Page: https://www.postgresql.org/docs/18/release-18.html
> > Description:
> >=20
> > 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.
> >=20
> > Code that catches 23503 to report that a row is still referenced stops
> > matching RESTRICT keys after upgrading, while NO ACTION keys still rais=
e
> > 23503. The same notes list the change to the XML error codes (cd838e200=
), so
> > this one seems to belong there as well.
>=20
> How do we want to handle such cases in the release notes?=C2=A0 The new c=
odes
> are not mentioned in the commit message, and there are no doc changes in =
the
> patch.

In my opinion, that should have a place in the "migration to v19" section o=
f
incompatibilities in the release notes.

I have no right to burden committers even more, but I'd say that such chang=
es
should be part of the commit message.

Yours,
Laurenz Albe