Re: BUG #6021: There is no difference between default and empty access privileges with \dp

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Robert Haas <robertmhaas(at)gmail(dot)com>
Cc: gszpetkowski(at)gmail(dot)com, 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-15 21:02:58
Message-ID: 17765.1305493378@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> On Thu, May 12, 2011 at 6:20 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> 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.

> I don't think that's too big a change. ISTM we ought to change
> something. Another idea would be to always show the permissions, even
> if nothing has been changed from the defaults.

That would require psql to have local knowledge about what the defaults
are, which is someplace I'd rather not go ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Matthijs Bomhoff 2011-05-16 09:10:23 Re: Re: Bug with STABLE function using the wrong snapshot (probably during planning)
Previous Message Robert Haas 2011-05-15 20:02:10 Re: Plperl trigger variables no longer global