From: Tom Lane <tgl@sss.pgh.pa.us>
To: Paul Foerster <paul.foerster@gmail.com>
cc: Adrian Klaver <adrian.klaver@aklaver.com>,
        pgsql-general list <pgsql-general@lists.postgresql.org>
Subject: Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION
In-reply-to: <DCCB9653-F185-454B-8B15-DE3997DA8AF8@gmail.com>
References: <5456A1D0-CD47-4315-9C65-71B27E7A2906@gmail.com> <78ec2af8-48f2-42c0-b317-cbb77cc5adc8@aklaver.com> <DCCB9653-F185-454B-8B15-DE3997DA8AF8@gmail.com>
Comments: In-reply-to Paul Foerster <paul.foerster@gmail.com>
	message dated "Tue, 26 Nov 2024 20:02:33 +0100"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1723210.1732656332.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 26 Nov 2024 16:25:32 -0500
Message-ID: <1723211.1732656332@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/1723211.1732656332%40sss.pgh.pa.us>
Precedence: bulk

Paul Foerster <paul.foerster@gmail.com> writes:
>> On 26 Nov 2024, at 17:56, Adrian Klaver <adrian.klaver@aklaver.com> wro=
te:
>> When you run the query again do you get the same two statements?

> Yes. I can repeat the above 4 steps as much as I want. The result remain=
s the same. I would have expected to have an empty result doing the final =
repeated select, but it shows exactly the same output.

I would have expected an empty result too.  Can you confirm that
p_ci_pipelines used to be a partition of something?  Can you show us
the full DDL (or psql \d+ output) for the partitioned table it
used to be part of, and for that matter also for p_ci_pipelines?
Did the FK used to reference the whole partitioned table, or just
this partition?

I'm suspicious that our repair recipe might not have accounted
for self-reference FKs fully, but that's just a gut feeling at
this point.

			regards, tom lane