Re: DROP OWNED BY - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: DROP OWNED BY
Date
Msg-id 20050814013713.GA6194@alvh.no-ip.org
Whole thread Raw
In response to Re: DROP OWNED BY  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Aug 13, 2005 at 10:09:35AM -0400, Tom Lane wrote:
> Alvaro Herrera <alvherre@alvh.no-ip.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)


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: distributed performance testing
Next
From: Greg Stark
Date:
Subject: Re: psql SET/RESET/SHOW tab completion