Re: DROP OWNED BY

On Sat, Aug 13, 2005 at 10:09:35AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> > 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.
>
> So refactor the GrantStmt code into a layer that translates to OIDs and
> another layer that does the work. The other way doesn't sound good to
> me; it is prone to race conditions against someone doing a RENAME.

Roger. I'll produce a patch for 8.2.

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"Es filósofo el que disfruta con los enigmas" (G. Coli)