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

2011/5/13 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> Grzegorz Szpetkowski <gszpetkowski(at)gmail(dot)com> writes:
>> I see that I just confused old PostgreSQL 8.3 curly bracket behaviour
>> with new 8.4/9.0 (I am using 8.3 all the time):
>
> Oh, you're right --- so I was mistaken to claim it had always been like
> that.  Before we started using array_to_string here, you *could* tell
> the difference between default privileges and no privileges.
>
> The precedent of previous versions makes it more plausible that we
> should print '{}' for no privileges, but I'm still not quite convinced.
> Anybody else have an opinion?
>
>                        regards, tom lane
>

I think that in such case it seems to be best solution (if any of
course) to provide "null" if object has no privileges:

"" - default ACL
"miriam=arwdDxt/miriam" - some ACL
"null" - no ACL

Regards,
Grzegorz Spetkowski