Re: pg_restore: All GRANTs on table fail when any one role is missing

Поиск
Список
Период
Сортировка
От Haribabu Kommi
Тема Re: pg_restore: All GRANTs on table fail when any one role is missing
Дата
Msg-id CAJrrPGcaF4uDdf_14FkUYGqcseU-5EyRXRLvsNWx3Yp9bvK=dQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_restore: All GRANTs on table fail when any one role is missing  (Moshe Jacobson <moshe@neadwerx.com>)
Ответы Re: pg_restore: All GRANTs on table fail when any one role is missing  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения
On Tue, Jul 24, 2018 at 5:14 AM Moshe Jacobson <moshe@neadwerx.com> wrote:
On Tue, Jul 17, 2018 at 12:02 PM Moshe Jacobson <moshe@neadwerx.com> wrote:
Here is a reproduction of the problem exclusively on 10.4. 

Can anyone validate this bug?

I am not able to reproduce the issue.

>REVOKE
>ERROR:  role "user1" does not exist
>Time: 0.134 ms

The process of grant doesn't execute, because of this reason, there are no permissions
on that table. In my test, after failure of user1, the next grant is successful. 

Try generating the sql file with pg_restore output and pass it to psql and check.

Regards,
Haribabu Kommi
Fujitsu Australia

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15303: Postgres fail to start if pg_wal is symlink,and works when it's a junction point
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Scanning all partition when more than 100 items in "where id in()" clause