Re: DROP OWNED BY fails to clean out pg_init_privs grants

Поиск
Список
Период
Сортировка
От Daniel Gustafsson
Тема Re: DROP OWNED BY fails to clean out pg_init_privs grants
Дата
Msg-id BEE6C7E7-0FD7-458B-AF4C-88EFFA8AAD7A@yesql.se
обсуждение исходный текст
Ответ на Re: DROP OWNED BY fails to clean out pg_init_privs grants  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: DROP OWNED BY fails to clean out pg_init_privs grants
Список pgsql-hackers
> On 26 May 2024, at 23:25, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> Hannu Krosing <hannuk@google.com> writes:
>> Attached is a minimal patch to allow missing roles in REVOKE command
> 
> FTR, I think this is a very bad idea.

Agreed, this is papering over a bug.  If we are worried about pg_upgrade it
would be better to add a check to pg_upgrade which detects this case and
advices the user how to deal with it.

--
Daniel Gustafsson




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: DROP OWNED BY fails to clean out pg_init_privs grants
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Improve conditional compilation for direct I/O alignment checks