Re: 12 to 13 migration, the privs error with pg_pltemplate

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
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 20:19:42
Message-ID: 6EA7B05C-A186-4288-9381-35E4219D39D7@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Dec 9, 2020, at 12:59 PM, Stephen Frost <sfrost(at)snowman(dot)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, whereas privs on the table are normal.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2020-12-09 20:26:14 Re: 12 to 13 migration, the privs error with pg_pltemplate
Previous Message Stephen Frost 2020-12-09 19:59:54 Re: 12 to 13 migration, the privs error with pg_pltemplate