Re: 12 to 13 migration, the privs error with pg_pltemplate - Mailing list pgsql-admin

From Scott Ribe
Subject Re: 12 to 13 migration, the privs error with pg_pltemplate
Date
Msg-id 6EA7B05C-A186-4288-9381-35E4219D39D7@elevated-dev.com
Whole thread Raw
In response to Re: 12 to 13 migration, the privs error with pg_pltemplate  (Stephen Frost <sfrost@snowman.net>)
Responses Re: 12 to 13 migration, the privs error with pg_pltemplate  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
> On Dec 9, 2020, at 12:59 PM, Stephen Frost <sfrost@snowman.net> wrote:
>
> 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..?

I'm pretty sure Tom Lane got it, because I see all sorts of privs in the pg_default_acl table that shouldn't be there,
whereasprivs on the table are normal. 




pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Next
From: Stephen Frost
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate