Re: DROP OWNED BY

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: DROP OWNED BY
Дата
Msg-id 20050814013713.GA6194@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: DROP OWNED BY  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: distributed performance testing
Следующее
От: Greg Stark
Дата:
Сообщение: Re: psql SET/RESET/SHOW tab completion