The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"
Дата
Msg-id CAHGQGwGUaC03FFdTFoHsCuDrrNvFvNVQ6xyd40==P25WvuBJjg@mail.gmail.com
обсуждение исходный текст
Ответы Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

The command tag of ALTER MATERIALIZED VIEW is basically
"ALTER MATERIALIZED VIEW". For example,

    =# ALTER MATERIALIZED VIEW test ALTER COLUMN j SET STATISTICS 100;
    ALTER MATERIALIZED VIEW
    =# ALTER MATERIALIZED VIEW test OWNER TO CURRENT_USER;
    ALTER MATERIALIZED VIEW
    =# ALTER MATERIALIZED VIEW test RENAME TO hoge;
    ALTER MATERIALIZED VIEW

This is ok and looks intuitive to users. But I found that the command tag of
ALTER MATERIALIZED VIEW RENAME COLUMN is "ALTER TABLE", not "ALTER VIEW".

    =# ALTER MATERIALIZED VIEW hoge RENAME COLUMN j TO x;
    ALTER TABLE

Is this intentional? Or bug?

Regards,

-- 
Fujii Masao



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

Предыдущее
От: Sergei Kornilov
Дата:
Сообщение: Re: allow online change primary_conninfo
Следующее
От: Ibrar Ahmed
Дата:
Сообщение: Re: Allow CREATE OR REPLACE VIEW to rename the columns