Re: Improve tab completion for REFRESH MATERIALIZED VIEW

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Improve tab completion for REFRESH MATERIALIZED VIEW
Дата
Msg-id CAHGQGwGjBQ0jaPVivFEfT-jh3HEU9VvjAX+1REh4Jy+wPDGcsw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Improve tab completion for REFRESH MATERIALIZED VIEW  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: Improve tab completion for REFRESH MATERIALIZED VIEW  (Fujii Masao <masao.fujii@gmail.com>)
Список pgsql-hackers
On Tue, Jan 26, 2016 at 10:25 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Tue, Jan 26, 2016 at 9:52 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>> Tab completion for REFRESH command is oddly with following scenario.
>>
>> =# REFRESH MATERIALIZED VIEW CONCURRENTLY hoge_mv [Tab]
>>
>> It shows only WITH DATA option without WITH NO DATA option.
>> Attached patch improves tab completion for WITH DATA/NO DATA option of
>> REFRESH MATERIALIZED VIEW.
>
> Correct. Nice catch and good patch.

The patch looks good to me.

While testing the patch, I found that
REFRESH MATERIALIZED VIEW <tab> doesn't list the materialized views.
I added the following change to the patch to fix that problem. Patch attached.

-       {"MATERIALIZED VIEW", NULL, NULL},
+       {"MATERIALIZED VIEW", NULL, &Query_for_list_of_matviews},

Regards,

--
Fujii Masao

Вложения

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: pg_lsn cast to/from int8
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Improve tab completion for REFRESH MATERIALIZED VIEW