I'm working on the promised DROP OWNED patch, and just noticed that it needs modifications to the Grant/Revoke machinery that are too invasive to consider for 8.1; the problem is that ExecuteGrantStmt takes textual names for objects and grantees, and what I have from pg_shdepend are Oids. Dropping the objects themselves is easy -- the problem is dropping grants to other objects.
So, instead of doing that, I think it's better to convert the Oids to names in the shared-dependency code. This should be rewritten after the next development period starts, for efficiency and cleanliness. Is anyone opposed to this idea? Further, is anyone opposed to the addition as a whole? I'm already a month and a half late with this part of the shdep patch, so if people think it's better to ship this release without it, so be it. (Of course I don't like that.) -- Alvaro Herrera (<alvherre[a]alvh.no-ip.org>) "Cuando no hay humildad las personas se degradan" (A. Christie) ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings