Feedback-ID: ie3de48e3:Fastmail
Date: Mon, 2 Mar 2026 13:14:40 +0100
From: =?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@kurilemu.de>
To: a.chodkowska@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19420: Zombie FK exists after partition is detached.
Message-ID: <202603021208.em4tblut6ssg@alvherre.pgsql>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <202603021010.lv5ugtfhqxdl@alvherre.pgsql>
Archived-At: <https://www.postgresql.org/message-id/202603021208.em4tblut6ssg%40alvherre.pgsql>
Precedence: bulk

On 2026-Mar-02, Álvaro Herrera wrote:

> [...] But we had bugs in this area
> in previous versions, so maybe the problem is simply that you set up the
> partitions with the old versions, and the FKs have not been updated.
> See one of those fixes, probably the most relevant one, here:
> 
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=53af9491a0439720094a11b72602952d79f59ac7
> 
> Version 16.0 already contained this fix, so it certainly shouldn't
> happen with 16.6;

Sorry, I misspoke -- the fix was not in 16.0, but for 16.5 in that
branch.  It's still true that 16.6 contains the fix.  Here's a rundown
of release numbers on each branch for that bugfix:

Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Branch: master Release: REL_18_BR [53af9491a] 2024-10-22 16:01:18 +0200
Branch: REL_17_STABLE Release: REL_17_1 [5914a22f6] 2024-10-22 16:01:18 +0200
Branch: REL_16_STABLE Release: REL_16_5 [2aaf2a28b] 2024-10-22 16:01:18 +0200
Branch: REL_15_STABLE Release: REL_15_9 [5d83bad6b] 2024-10-22 16:01:18 +0200
Branch: REL_14_STABLE Release: REL_14_14 [46a8c27a7] 2024-10-22 16:01:18 +0200
Branch: REL_13_STABLE Release: REL_13_17 [d20194cea] 2024-10-22 16:01:18 +0200

    Restructure foreign key handling code for ATTACH/DETACH
    
    ... to fix bugs when the referenced table is partitioned.


(Here I must decidedly credit
    Jehan-Guillaume de Rorthais <jgdr@dalibo.com>
for working on this fix.)

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"La fuerza no está en los medios físicos
sino que reside en una voluntad indomable" (Gandhi)