From: Stephen Frost <sfrost@snowman.net>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Date: Wed, 9 Dec 2020 14:24:06 -0500
Message-ID: <20201209192406.GD16415@tamriel.snowman.net> (raw)
In-Reply-To: <B292176F-B507-498F-975B-3548D73A8352@elevated-dev.com>
References: <074FE83A-E924-4787-9E68-27EB9CE142B3@elevated-dev.com>
<3264512.1607456932@sss.pgh.pa.us>
<154608A6-0F38-4BE8-B3F4-3E3308691F91@elevated-dev.com>
<2BD26D52-19B8-42CD-860D-B9AE21AF5C61@elevated-dev.com>
<3632844.1607534358@sss.pgh.pa.us>
<68634B7E-3AD0-42A3-9A2D-EC3988E755E4@elevated-dev.com>
<20201209184925.GA16415@tamriel.snowman.net>
<B292176F-B507-498F-975B-3548D73A8352@elevated-dev.com>
Greetings,
* Scott Ribe (scott_ribe@elevated-dev.com) wrote:
> > On Dec 9, 2020, at 11:49 AM, Stephen Frost <sfrost@snowman.net> wrote:
> > REVOKE'ing the privileges on the
> > catalog tables/columns that are causing an issue should resolve it
> > though.
>
> I tried REVOKE ALL, no joy. Given where Tom pointed me, perhaps I need to give ALTER DEFAULT PRIVILEGES a try.
Are you sure you have privileges to perform the REVOKE and that it
actually did something..? Check the results in psql using:
=> \dp pg_catalog.pg_pltemplate
(or whatever catalog table it is the GRANT's are being created for
in the pg_dump)
What you'd want is something like:
Access privileges
Schema | Name | Type | Access privileges | Column privileges | Policies
------------+---------------+-------+---------------------------+-------------------+----------
pg_catalog | pg_pltemplate | table | postgres=arwdDxt/postgres+| |
| | | =r/postgres | |
(1 row)
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, scott_ribe@elevated-dev.com, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
In-Reply-To: <20201209192406.GD16415@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox