Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKKaq-00000000nRu-3duz for pgsql-docs@arkaria.postgresql.org; Fri, 23 Oct 2026 19:06:21 +0000 Received: from localhost ([127.0.0.1]:42574 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xKKaq-0000000GmDO-1i72 for pgsql-docs@arkaria.postgresql.org; Fri, 23 Oct 2026 19:06:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:40798) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKKaq-0000000GmDG-0WF8 for pgsql-docs@lists.postgresql.org; Fri, 23 Oct 2026 19:06:20 +0000 Received: from momjian.us ([72.94.173.45]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xKKan-00000000crX-2RBw for pgsql-docs@lists.postgresql.org; Fri, 23 Oct 2026 19:06:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2026010100; h=In-Reply-To:Content-Type:MIME-Version:References:Message-ID: Subject:Cc:To:From:Date:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description; bh=64qnkQkJCMdugC7l+cItiq/DgnDl77DteuUXZBbfBq8=; b=f8OuV 3AGLQvcPO3AG2T+alQBFO8yI7OifOMdoY5sbf2SLWQNPAYnTqcI76KMvt3jVjnP8kg0S0aFjncQNg UHdYjq0RqDxHhXDZPfnVe6kuux1B4ceb90DdlrXRa73wGVaBDarv59gx3K1sjNaEvdaVobTvsiio1 vlOttdi3lCVBnfe/pMkT+2rOcUOKHatLSfnujf/1mc1S1bwi/KMv59fxPirJKpD7LQr2rC+sHLhKO gc2TooiVdrb1MHpwNMARvJrHwzTZe+UcUvW7jCciMEFPPW+6oSaeBvlz4CZnyCBy1nI54PB+WeLR1 G4weQPdy5WoBjbpnzoy3EKcVmxS8w==; Received: from bruce by momjian.us with local (Exim 4.98.2) (envelope-from ) id 1xKKaj-0000000BggS-3OXi; Fri, 23 Oct 2026 15:06:13 -0400 Date: Fri, 23 Oct 2026 15:06:13 -0400 From: Bruce Momjian To: Kacper Kuras Cc: David Rowley , Daniel Gustafsson , Laurenz Albe , "pgsql-docs@lists.postgresql.org" , Peter Eisentraut Subject: Re: E.6.3.2.1. Constraints Message-ID: References: <178982939588.1243.6087398342138761960@wrigleys.postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 https://momjian.us EDB https://enterprisedb.com Do not let urgent matters crowd out time for investment in the future.