Ron <ronljohnsonjr@xxxxxxxxx> 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
