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

Поиск
Список
Период
Сортировка
От Grzegorz Szpetkowski
Тема Re: BUG #6021: There is no difference between default and empty access privileges with \dp
Дата
Msg-id BANLkTikA5vdtOrwBPZbmpuwd1to8JmMt9Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #6021: There is no difference between default and empty access privileges with \dp  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #6021: There is no difference between default and empty access privileges with \dp
Следующее
От: "Alessio Pollero"
Дата:
Сообщение: BUG #6025: psql show password inserted in database restore