Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.200.121\))
Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH
 PARTITION/DETACH PARTITION
From: Paul Foerster <paul.foerster@gmail.com>
In-Reply-To: <1900196.1732733556@sss.pgh.pa.us>
Date: Fri, 29 Nov 2024 07:58:38 +0100
Cc: Adrian Klaver <adrian.klaver@aklaver.com>,
 pgsql-general list <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <8DE45ACE-D7B0-4261-8003-7404518AC5A0@gmail.com>
References: <5456A1D0-CD47-4315-9C65-71B27E7A2906@gmail.com>
 <78ec2af8-48f2-42c0-b317-cbb77cc5adc8@aklaver.com>
 <DCCB9653-F185-454B-8B15-DE3997DA8AF8@gmail.com>
 <1723211.1732656332@sss.pgh.pa.us>
 <F103529F-49ED-4A2F-9EB1-19AFC561635A@gmail.com>
 <1900196.1732733556@sss.pgh.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>,
 Alvaro Herrera <alvherre@alvh.no-ip.org>
Archived-At: <https://www.postgresql.org/message-id/8DE45ACE-D7B0-4261-8003-7404518AC5A0%40gmail.com>
Precedence: bulk

Hi Tom, hi Alvaro,

> On 27 Nov 2024, at 19:52, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>=20
> Okay, so I was able to reproduce this from scratch on HEAD:

great, thanks.

> I doubt that there's anything actually wrong with the catalog state at
> this point (perhaps Alvaro would confirm that).  That leads to the
> conclusion that what's wrong is the release notes' query for fingering
> broken constraints, and it needs some additional test to avoid
> complaining about (I suspect) self-reference cases.

In the meantime, I updated the whole company. The one test database =
actually was the only database that this was returned. I found no other =
occurrences.

As I understand it, the worst thing that could happen is that one or =
more rows end up in a detached partition table which should actually be =
in another partition, right? Since there were no rows, no harm could =
have been done. Also, since this is a self reference, the wrong table is =
also the right one.

Again, thanks very much for clarifying this.

Cheers
Paul=