| From: | Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com> |
|---|---|
| To: | moshe(at)neadwerx(dot)com |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: pg_restore: All GRANTs on table fail when any one role is missing |
| Date: | 2018-07-27 08:52:05 |
| Message-ID: | CAJrrPGcaF4uDdf_14FkUYGqcseU-5EyRXRLvsNWx3Yp9bvK=dQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, Jul 24, 2018 at 5:14 AM Moshe Jacobson <moshe(at)neadwerx(dot)com> wrote:
> On Tue, Jul 17, 2018 at 12:02 PM Moshe Jacobson <moshe(at)neadwerx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Langote | 2018-07-27 08:57:49 | Re: Scanning all partition when more than 100 items in "where id in ()" clause |
| Previous Message | PG Bug reporting form | 2018-07-27 08:37:55 | BUG #15303: Postgres fail to start if pg_wal is symlink, and works when it's a junction point |