HELP! BUG? pg_dump mucks up grant/revoke

Поиск
Список
Период
Сортировка
От Keith F Irwin
Тема HELP! BUG? pg_dump mucks up grant/revoke
Дата
Msg-id Pine.LNX.4.33.0107070852060.13101-100000@localhost.localdomain
обсуждение исходный текст
Ответы Re: HELP! BUG? pg_dump mucks up grant/revoke
Список pgsql-general
Hi:

I'm using pg 7.1.2.

I've got a database with views which have permissions granted to a certain
user.  Defined something like:

    create view whatever....

    revoke all on whatever from user
    grant select on whatever to user

(If I get the syntax wrong, it doesn't matter here.)

THEN, I do a pg_dump:

    pg_dump --attribute-inserts database > dump.sql

all well and good expect for one thing: the grant/revoke lines appear
BEFORE the create view definitions, so when I read the dump back into
postgres via:

    dropdb database
    createdb database
    cat dump.sql | psql database

I get "relation doesn't exist" errors and my "user" no longer has
permission to use those views.  This is a bug, isn't it?

Keith


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

Предыдущее
От: Vince Vielhaber
Дата:
Сообщение: Re: JDBC 2.0 support?
Следующее
От: Fabrice Scemama
Дата:
Сообщение: Re: VACUUM ANALYZE