pg_dump is broken by recent privileges changes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема pg_dump is broken by recent privileges changes
Дата
Msg-id 7365.1044116883@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: pg_dump is broken by recent privileges changes  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
In CVS tip, create an empty database.  pg_dump it.  Try to restore the
dump.  The first thing it does is

REVOKE ALL ON SCHEMA public FROM PUBLIC;

which fails with

ERROR:  dependent privileges exist (use CASCADE to revoke them too)

This message seems incorrect --- what is a dependent privilege, and
why would PUBLIC have any?  All I see in pg_namespace is
public             |        1 | {=UC/postgres}

Also, pg_dump itself seems confused --- the full text of a dump from
an empty DB is (omitting comment lines)

\connect - postgres
REVOKE ALL ON SCHEMA public FROM PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;
GRANT ALL ON SCHEMA public TO PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;

which is not only inefficient but wrong, since public surely should
have privileges when the dust settles.
        regards, tom lane


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

Предыдущее
От: Kevin Brown
Дата:
Сообщение: Re: sync()
Следующее
От: Kevin Brown
Дата:
Сообщение: Re: On file locking