Re: BUG #19420: Zombie FK exists after partition is detached.

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "a(dot)chodkowska(at)gmail(dot)com" <a(dot)chodkowska(at)gmail(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #19420: Zombie FK exists after partition is detached.
Date: 2026-02-27 14:20:09
Message-ID: CAKFQuwYdfE+5ERXCufTVpffe1bL1hGKxtWuP=oMKse83iedY3Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Friday, February 27, 2026, PG Bug reporting form <noreply(at)postgresql(dot)org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference: 19420
> Logged by: Agnieszka Chodkowska
> Email address: a(dot)chodkowska(at)gmail(dot)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.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2026-02-27 14:44:20 Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor>
Previous Message Marcel Hofstetter 2026-02-27 13:36:30 Re: BUG #19404: manpages are missing in 18.x source.tar.gz