Re: Tab-comletion for RLS

Поиск
Список
Период
Сортировка
От Masahiko Sawada
Тема Re: Tab-comletion for RLS
Дата
Msg-id CAD21AoDpRxNten2Fskz3TYbZmzO-tHfqcPAid6SQh-rL6PLx-w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Tab-comletion for RLS  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Tab-comletion for RLS  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, Dec 10, 2015 at 11:07 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Tue, Dec 8, 2015 at 8:32 AM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>> I found some lacks of tab-completion for RLS in 9.5.
>>
>> * ALTER POLICY [TAB]
>> I expected to appear the list of policy name, but nothing is appeared.
>>
>> * ALTER POLICY hoge_policy ON [TAB]
>> I expected to appear the list of table name related to specified policy, but
>> all table names are appeared.
>>
>> * ALTER POLICY ... ON ... TO [TAB]
>> I expected to appear { role_name | PUBLIC | CURRENT_USER | SESSION_USER },
>> but only role_name and PUBLIC are appeared.
>> Same problem is exists in
>> "
>> CREATE POLICY ... ON ... TO [TAB]
>> "
>> .
>>
>> #1 and #2 problems are exist in 9.5 or later, but #3 is exist in only 9.5
>> because it's unintentionally fixed by
>> 2f8880704a697312d8d10ab3a2ad7ffe4b5e3dfd commit.
>> I think we should apply the necessary part of this commit for 9.5 as well,
>> though?
>>
>> Attached patches are:
>> * 000_fix_tab_completion_rls.patch
>>   fixes #1, #2 problem, and is for master branch and REL9_5_STABLE.
>> * 001_fix_tab_completion_rls_for_95.patch
>>   fixes #3 problem, and is for only REL9_5_STABLE.
>
> I've committed 000 and back-patched it to 9.5.  I'm not quite sure
> what to do about 001; maybe it's better to back-port the whole commit
> rather than just bits of it.
>

Yes, I agree with back-port the whole commit.

Regards,

--
Masahiko Sawada



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andreas Seltenreich
Дата:
Сообщение: Re: [sqlsmith] Failed to generate plan on lateral subqueries
Следующее
От: Masahiko Sawada
Дата:
Сообщение: Re: Support for N synchronous standby servers - take 2