Re: partitioned tables referenced by FKs - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: partitioned tables referenced by FKs
Date
Msg-id 20190319114920.GA10432@alvherre.pgsql
Whole thread Raw
In response to Re: partitioned tables referenced by FKs  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Responses Re: partitioned tables referenced by FKs
List pgsql-hackers
On 2019-Mar-19, Amit Langote wrote:

> Will it suffice or be OK if we skipped invoking the pre-drop callback for
> objects that are being "indirectly" dropped?  I came up with the attached
> patch to resolve this problem, if that idea has any merit.  We also get
> slightly better error message as seen the expected/foreign_key.out changes.

I don't think this works ... consider putting some partition in a
different schema and then doing DROP SCHEMA CASCADE.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Compressed TOAST Slicing
Next
From: Alvaro Herrera
Date:
Subject: Re: Contribution to Perldoc for TestLib module in Postgres