pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Kacper Kuras <kacperkuras@hotmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>
Cc: Daniel Gustafsson <daniel@yesql.se>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs@lists.postgresql.org <pgsql-docs@lists.postgresql.org>
Cc: Peter Eisentraut <peter@eisentraut.org>
Subject: Re: E.6.3.2.1. Constraints
Date: Fri, 23 Oct 2026 15:06:13 -0400
Message-ID: <atuwJar911aZUEPm@momjian.us> (raw)
In-Reply-To: <VI0P193MB3111C432A6EEE8B74AD80A30BF912@VI0P193MB3111.EURP193.PROD.OUTLOOK.COM>
References: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org>
	<arGAwYKNjCQGpHUh@momjian.us>
	<f1828bd03077c2cbde82acc220925cfa968aad4e.camel@cybertec.at>
	<BE714093-D030-4A1C-BCBA-EFF878248F60@yesql.se>
	<arKFWMunv0Kzo_vm@momjian.us>
	<CAApHDvqBZgFGWSRnpwcFKxQ2_maKs0ujW-f=UjhGd567uY8q+g@mail.gmail.com>
	<VI0P193MB3111C432A6EEE8B74AD80A30BF912@VI0P193MB3111.EURP193.PROD.OUTLOOK.COM>

On Sat, Oct 10, 2026 at 12:41:13PM +0000, Kacper Kuras wrote:
> Here is a patch for this case, against REL_18_STABLE, that adds
> 086c84b23 to the 18 release notes:
> 
>     Report RESTRICT foreign key violations with SQLSTATE 23001
>     (restrict_violation) instead of 23503 (foreign_key_violation)
>     (Peter Eisentraut)
> 
> I put it in the Constraints section with the other foreign key items.
> Laurenz suggested the migration section; cd838e200 isn't listed there
> either, but I'm happy to move it if that's preferred.
> 
> The patch also fixes a doubled "the" in the collation entry of the
> same section.
> 
> Peter, CC'ing you since it's your commit.

Patch applied, though I moved it to the "incompatibilities" section,
where I felt it made more sense.

I am still unclear how I will catch such changes in the future without
requiring users to report them.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.






view thread (10+ messages)  latest in thread

Message-ID: <atuwJar911aZUEPm@momjian.us>
Permalink:  ../atuwJar911aZUEPm@momjian.us/
Also on:    postgresql.org/message-id/atuwJar911aZUEPm@momjian.us

 · 

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: bruce@momjian.us, kacperkuras@hotmail.com, dgrowleyml@gmail.com, daniel@yesql.se, laurenz.albe@cybertec.at, pgsql-docs@lists.postgresql.org, peter@eisentraut.org
  Subject: Re: E.6.3.2.1. Constraints
  In-Reply-To: <atuwJar911aZUEPm@momjian.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox