Re: BUG #19420: Zombie FK exists after partition is detached. - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19420: Zombie FK exists after partition is detached.
Date
Msg-id CAKFQuwYdfE+5ERXCufTVpffe1bL1hGKxtWuP=oMKse83iedY3Q@mail.gmail.com
Whole thread
In response to BUG #19420: Zombie FK exists after partition is detached.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Friday, February 27, 2026, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      19420
Logged by:          Agnieszka Chodkowska
Email address:      a.chodkowska@gmail.com
PostgreSQL version: 16.6
Operating system:   Linux, Debian 12.2.0 64 bit
Description:       

I try the following methods:
partman.run_maintenance('tst.child_test_1')
partman.run_maintenance()
ALTER TABLE tst.child_test_1 DETACH PARTITION <child_test_p_20260218>

This bug report list is probably not presently the best place to report this.  The error seems like it most likely manifests from pgpartman and should be reported there.   Reporting bugs against unsupported minor releases is also usually a bit problematic.

To keep it here a full reproducer using only core features and a supported release would be requested.

David J.

pgsql-bugs by date:

Previous
From: Marcel Hofstetter
Date:
Subject: Re: BUG #19404: manpages are missing in 18.x source.tar.gz
Next
From: Richard Guo
Date:
Subject: Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34