Ron <ronljohnso...@gmail.com> writes: > That works *sometimes*, but not when we *really* want it to work.
> test=# begin transaction;
> BEGIN
> test=# ALTER TABLE sales_header DETACH PARTITION sales_header_202001;
> ERROR: removing partition "sales_header_202001" violates foreign key
> constraint "sales_detail_cust_id_order_ts_fkey"
That I think you're gonna have to live with. DETACH PARTITION isn't
something we can defer to end of transaction.
regards, tom lane
