Re: Restoring default privileges on objects - Mailing list pgsql-general

From Erik Wienhold
Subject Re: Restoring default privileges on objects
Date
Msg-id 2094101432.333909.1693338630182@office.mailbox.org
Whole thread Raw
In response to Re: Restoring default privileges on objects  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Restoring default privileges on objects
Next
From: Alan Stange
Date:
Subject: Re: [INTERNET] Re: auto vacuum question