Re: Restoring default privileges on objects

Поиск
Список
Период
Сортировка
От Erik Wienhold
Тема Re: Restoring default privileges on objects
Дата
Msg-id 2094101432.333909.1693338630182@office.mailbox.org
обсуждение исходный текст
Ответ на Re: Restoring default privileges on objects  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> On 29/08/2023 21:27 CEST Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Yeah, perhaps.  The reason it so seldom comes up is that a state of
> zero privileges is extremely rare (because it's useless in practice).
>
> That being the case, if we were to do something about this, I'd vote
> for changing the display of zero-privileges to "(none)" or something
> along that line, rather than changing the display of NULL, which
> people are accustomed to.

+1

> Fixing \dp to honor "\pset null" for this might be a reasonable
> thing to do too.  I'm actually a bit surprised that that doesn't
> work already.

Looks like all commands in src/bin/psql/describe.c set nullPrint = NULL.  Has
been that way since at least 1999.

--
Erik



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Restoring default privileges on objects
Следующее
От: Alan Stange
Дата:
Сообщение: Re: [INTERNET] Re: auto vacuum question