Re: BUG #6021: There is no difference between default and empty access privileges with \dp - Mailing list pgsql-bugs

From Grzegorz Szpetkowski
Subject Re: BUG #6021: There is no difference between default and empty access privileges with \dp
Date
Msg-id BANLkTikA5vdtOrwBPZbmpuwd1to8JmMt9Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6021: There is no difference between default and empty access privileges with \dp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
2011/5/13 Tom Lane <tgl@sss.pgh.pa.us>:
> Grzegorz Szpetkowski <gszpetkowski@gmail.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. =A0Before 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?
>
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0regards, 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=3DarwdDxt/miriam" - some ACL
"null" - no ACL

Regards,
Grzegorz Spetkowski

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6021: There is no difference between default and empty access privileges with \dp
Next
From: "Alessio Pollero"
Date:
Subject: BUG #6025: psql show password inserted in database restore