On 12/7/20 3:40 PM, Tom Lane wrote:
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.
Very sad, since it would simplify the archiving of the 24x365 system we're
porting from Oracle to RDS Postgresql.
--
Angular momentum makes the world go 'round.
