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

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: 12 to 13 migration, the privs error with pg_pltemplate
Дата
Msg-id 20201209190454.GB16415@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: 12 to 13 migration, the privs error with pg_pltemplate  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 12 to 13 migration, the privs error with pg_pltemplate
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: 12 to 13 migration, the privs error with pg_pltemplate