"psql \dp showing empty Access privileges column for {}"
<gszpetkow...@gmail.com> writes:
> Description: There is no difference between default and empty access
> privileges with \dp
Yeah. It's been like that since forever, and nobody's complained
before, possibly because revoking all privileges for everybody isn't
a particularly useful real-world case.
One possibility is to start showing "default" when the ACL is null,
which would be quite easy to implement:
COALESCE(array_to_string(c.relacl, E'\n'), 'default')
But that might be too big a change. Or we could take the opposite
tack of changing the display in the no-privileges case; but I don't
see a similarly compact way to do that.
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
