| 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: | Whole Thread | Raw Message | 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 |