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
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 |