Re: REVOKE to an user that doesn't exist

Поиск
Список
Период
Сортировка
От Moreno Andreo
Тема Re: REVOKE to an user that doesn't exist
Дата
Msg-id 2f1b90d6-9868-96fa-ab2e-1bb8713b52f2@evolu-s.it
обсуждение исходный текст
Ответ на Re: REVOKE to an user that doesn't exist  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Дерево обсуждения 
Il 12/12/2018 16:01, Tom Lane ha scritto:
>
> The safest way to clean it up manually would be to set the pg_proc.proacl
> field for that function to NULL.  If there are other grants about the
> function, you could try removing the bad entry, but it would likely be
> safer to just re-grant after the upgrade.
>
Setting the column (and several others from other tables such as 
pg_class) to null made me possible to upgrade the cluster. After the 
upgrade, I issued the necessary GRANTs and everything is up & running on 
Postgres 10 now!

Thanks again

Moreno.-

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

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: conditionally terminate psql script
Следующее
От: "Daniel Verite"
Дата:
Сообщение: Re: Creating 2D arrays for pg_copy_from, reading tab-delimted textfile that contains comma and double quotes