| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | gszpetkowski(at)gmail(dot)com |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #6021: There is no difference between default and empty access privileges with \dp |
| Date: | 2011-05-12 22:20:30 |
| Message-ID: | 11419.1305238830@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"psql \dp showing empty Access privileges column for {}" <gszpetkowski(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2011-05-12 22:46:40 | Re: Re: Bug with STABLE function using the wrong snapshot (probably during planning) |
| Previous Message | Bernd Helmle | 2011-05-12 22:08:43 | Re: BUG #6024: pg_dump won't dump ALTERed inherited fields |