Re: Bug in pg_dump in 7.4.6?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug in pg_dump in 7.4.6?
Дата
Msg-id 10736.1105542891@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug in pg_dump in 7.4.6?  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Bug in pg_dump in 7.4.6?  (Greg Stark <gsstark@mit.edu>)
Список pgsql-general
Greg Stark <gsstark@mit.edu> writes:
> It seems the spurious SET SESSION AUTHORIZATION commands appear after any
> REVOKE/GRANT pair.

Oh, right.  In order to handle grants with GRANT OPTION, the dump data
may need to include SET SESSION AUTHORIZATION commands; so the code
assumes that it doesn't know the authorization any more after emitting
an ACL entry.  Not a bug.  It could possibly be smarter (eg grep the
text for "SET SESSION AUTHORIZATION" before deciding this) but since
that's not the default mode anymore anyway, I'm not very concerned.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Re: OID of current function
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: OID of current function