From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erik Wienhold <ewie@ewie.name>
cc: Stuart McGraw <smcg4191@mtneva.com>, pgsql-general@lists.postgresql.org
Subject: Re: Restoring default privileges on objects
In-reply-to: <1550267563.330669.1693335893138@office.mailbox.org>
References: <96d6885a-5e25-9ae8-4a1a-d7e557a5fe9c@mtneva.com> <1166048641.281962.1693308151542@office.mailbox.org> <1006397.1693318485@sss.pgh.pa.us> <efdd465d-a795-6188-7f71-7cdb4b2be031@mtneva.com> <1550267563.330669.1693335893138@office.mailbox.org>
Comments: In-reply-to Erik Wienhold <ewie@ewie.name>
	message dated "Tue, 29 Aug 2023 21:04:53 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <31245.1693337238.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 29 Aug 2023 15:27:18 -0400
Message-ID: <31246.1693337238@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/31246.1693337238%40sss.pgh.pa.us>
Precedence: bulk

Erik Wienhold <ewie@ewie.name> writes:
> On 29/08/2023 18:43 CEST Stuart McGraw <smcg4191@mtneva.com> wrote:
>> Shouldn't psql put *something* (like "(default)" or "-") in the
>> "Access privileges" column to indicate that?  Or conversely,
>> something (like "(none)"?) in the revoked case?

> Indeed, that's confusing.  Command \dp always prints null as empty strin=
g [1].
> So \pset null '(null)' has no effect.

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.

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.

			regards, tom lane