| From: | Stephen Frost <sfrost(at)snowman(dot)net> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: 12 to 13 migration, the privs error with pg_pltemplate |
| Date: | 2020-12-09 19:59:54 |
| Message-ID: | 20201209195954.GF16415@tamriel.snowman.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Greetings,
* Scott Ribe (scott_ribe(at)elevated-dev(dot)com) wrote:
> > On Dec 9, 2020, at 12:24 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> >
> > Are you sure you have privileges to perform the REVOKE and that it
> > actually did something..? Check the results in psql using:
>
> no errors, and your example exactly matches what I see there
Well, pg_dump here doesn't emit any GRANT commands for that table when
run and the table has those privileges, so something doesn't add up.
Are you sure you're looking at the right database? Do you see GRANT or
REVOKE commands for that table when you run pg_dump by hand..?
Thanks,
Stephen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2020-12-09 20:19:42 | Re: 12 to 13 migration, the privs error with pg_pltemplate |
| Previous Message | Scott Ribe | 2020-12-09 19:42:19 | Re: 12 to 13 migration, the privs error with pg_pltemplate |