On Sat, Aug 13, 2005 at 10:09:35AM -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> 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) ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match