MIME-Version: 1.0
In-Reply-To: <19420-ec7f929dce3a7e14@postgresql.org>
References: <19420-ec7f929dce3a7e14@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 27 Feb 2026 07:20:09 -0700
Message-ID: <CAKFQuwYdfE+5ERXCufTVpffe1bL1hGKxtWuP=oMKse83iedY3Q@mail.gmail.com>
Subject: Re: BUG #19420: Zombie FK exists after partition is detached.
To: "a.chodkowska@gmail.com" <a.chodkowska@gmail.com>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000048903d064bceef4b"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwYdfE%2B5ERXCufTVpffe1bL1hGKxtWuP%3DoMKse83iedY3Q%40mail.gmail.com>
Precedence: bulk

--00000000000048903d064bceef4b
Content-Type: text/plain; charset="UTF-8"

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.

--00000000000048903d064bceef4b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, February 27, 2026, PG Bug reporting form &lt;<a href=3D"mailto:n=
oreply@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquote=
 class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc soli=
d;padding-left:1ex">The following bug has been logged on the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19420<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Agnieszka Chodkowska<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:a.chodkowska@gmail.com=
">a.chodkowska@gmail.com</a><br>
PostgreSQL version: 16.6<br>
Operating system:=C2=A0 =C2=A0Linux, Debian 12.2.0 64 bit<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
<br>I try the following methods:<br>
partman.run_maintenance(&#39;tst.<wbr>child_test_1&#39;)<br>
partman.run_maintenance()<br>
ALTER TABLE tst.child_test_1 DETACH PARTITION &lt;child_test_p_20260218&gt;=
<br>
</blockquote><div><br></div><div>This bug report list is probably not prese=
ntly the best place to report this.=C2=A0 The error seems like it most like=
ly manifests from pgpartman and should be reported there. =C2=A0 Reporting =
bugs against unsupported minor releases is also usually a bit problematic.<=
/div><div><br></div><div>To keep it here a full reproducer using only core =
features and a supported release would be requested.</div><div><br></div><d=
iv>David J.</div><div><br></div>

--00000000000048903d064bceef4b--