public inbox for [email protected]  

help / color / mirror / Atom feed

From: PG Bug reporting form <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: BUG #19420: Zombie FK exists after partition is detached.
Date: Fri, 27 Feb 2026 09:09:36 +0000
Message-ID: <[email protected]> (raw)

The following bug has been logged on the website:

Bug reference:      19420
Logged by:          Agnieszka Chodkowska
Email address:      [email protected]
PostgreSQL version: 16.6
Operating system:   Linux, Debian 12.2.0 64 bit
Description:        

I have child table  with FK defined as folllows

ALTER TABLE IF EXISTS tst.child_test_1
    ADD CONSTRAINT child_test_1_parent_id_parent_part_by_fkey FOREIGN KEY
(parent_id, parent_part_by)
    REFERENCES tst.maintenance_test_1_p20260218 (id, part_by) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE CASCADE;

I updated configuration according to documentation as follows:
retention_keep_table=false ,
retention_keep_index = false

Somehow postgresql retains the foreign keys of the detached/dropped
partitions, to the parent table partitions.

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>

The error persisted regardless of the method used.

view thread (3+ messages)  latest in thread

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