Re: DROP OWNED BY doesn't work - Mailing list pgsql-patches

From Tom Lane
Subject Re: DROP OWNED BY doesn't work
Date
Msg-id 27722.1156089957@sss.pgh.pa.us
Whole thread Raw
In response to Re: DROP OWNED BY doesn't work  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: DROP OWNED BY doesn't work  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Ok, this patch implements more or less this idea; except that instead of
> checking the list of implicit dependencies for later objects, we iterate
> twice on the list of objects to delete, and create a list of implicit
> dependencies on all of them the first time, and delete those not on that
> list the second time.

In the light of morning it occurs to me that probably the best code
factoring for this is for dependency.c to export a
performMultipleDeletions() function that takes an objectAddresses list
of targets and does all the dependency-chasing internally.  This would
reduce the amount of cruft that has to be exported from dependency.c.

Other than that, the patch looks plausible in a very fast scan.

            regards, tom lane

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: DROP OWNED BY doesn't work
Next
From: Alvaro Herrera
Date:
Subject: Re: DROP OWNED BY doesn't work