Re: DROP OWNED BY fails to clean out pg_init_privs grants

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DROP OWNED BY fails to clean out pg_init_privs grants
Дата
Msg-id 1562011.1714450202@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: DROP OWNED BY fails to clean out pg_init_privs grants  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: DROP OWNED BY fails to clean out pg_init_privs grants  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-hackers
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> My solution to this was to rely on the fact that the bootstrap superuser is
> assigned OID 10 regardless of its name.

Yeah, I wrote it that way to start with too, but reconsidered
because

(1) I don't like hard-coding numeric OIDs.  We can avoid that in C
code but it's harder to do in SQL.

(2) It's not clear to me that this test couldn't be run by a
non-bootstrap superuser.  I think "current_user" is actually
the correct thing for the role executing the test.

            regards, tom lane



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

Предыдущее
От: Richard Guo
Дата:
Сообщение: Re: Eager aggregation, take 3
Следующее
От: Richard Guo
Дата:
Сообщение: Re: [PATCH] Fix bug when calling strncmp in check_authmethod_valid