On 2025-Mar-19, Adithya Kumaranchath wrote:
> --Scenario 1: Detach parent partition
> alter table table1 detach partition table1_202402
>
> ERROR: Key (parnt_id, archive_dt)=(a6955e39-22eb-48e2-bd59-cad9650a4f6b,
> 2024-02-11) is still referenced from table "table1_child_202402".removing
> part
Hi all,
Issue: After upgrading to PostgreSQL version 16.6 from 15. I see a different
behavior when detaching partitions with FK. Scenario 1 works on 15 but stopped
working on 16.x
CREATE TABLE table1 (
enti_id varchar(75) NOT NULL,
archive_dt date NOT NULL DEFAULT '-01-01'::date
