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

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, 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:04:54
Message-ID: 20201209190454.GB16415@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Greetings,

* Tom Lane (tgl(at)sss(dot)pgh(dot)pa(dot)us) wrote:
> Stephen Frost <sfrost(at)snowman(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2020-12-09 19:20:32 Re: 12 to 13 migration, the privs error with pg_pltemplate
Previous Message Tom Lane 2020-12-09 19:02:18 Re: 12 to 13 migration, the privs error with pg_pltemplate