public inbox for [email protected]
help / color / mirror / Atom feedFrom: Álvaro Herrera <[email protected]>
To: [email protected]
To: [email protected]
Subject: Re: BUG #19420: Zombie FK exists after partition is detached.
Date: Mon, 2 Mar 2026 13:14:40 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
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=53af9491a0439720094a11b72602952d7...
>
> 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 <[email protected]>
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 <[email protected]>
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)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: BUG #19420: Zombie FK exists after partition is detached.
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox