Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
Date
Msg-id 90866.1731253608@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> So it looks like we should suggest to save the output of the query,
> execute each DROP followed by each ADD, and if the latter fails, fix the
> violations and retry the ADD.

Right.  I'll make it so -- thanks for doing the legwork on
creating the query!

            regards, tom lane

pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: proposal: schema variables
Next
From: Tom Lane
Date:
Subject: Re: Join removal and attr_needed cleanup