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

From Stephen Frost
Subject Re: 12 to 13 migration, the privs error with pg_pltemplate
Date
Msg-id 20201209190454.GB16415@tamriel.snowman.net
Whole thread Raw
In response to Re: 12 to 13 migration, the privs error with pg_pltemplate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Greetings,

* Tom Lane (tgl@sss.pgh.pa.us) wrote:
> Stephen Frost <sfrost@snowman.net> writes:
> > (I'm generally not a fan of hacking around in the catalog tables
> > directly...)
>
> I'd avoid that too, except he's about to migrate off the instance
> entirely, so fine points like whether dependencies are up-to-date
> shouldn't cause too much problem.

A REVOKE of the privilege shouldn't cause any issues either and avoids
hacking on the catalog.  It's also simpler to un-do should they need to
revert to the old system for whatever reason, and avoids making people
feel comfortable with modifying the catalog tables directly.

Thanks,

Stephen

Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Next
From: Scott Ribe
Date:
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate