The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN" - Mailing list pgsql-hackers

From Fujii Masao
Subject The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"
Date
Msg-id CAHGQGwGUaC03FFdTFoHsCuDrrNvFvNVQ6xyd40==P25WvuBJjg@mail.gmail.com
Whole thread Raw
Responses Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: allow online change primary_conninfo
Next
From: Ibrar Ahmed
Date:
Subject: Re: Allow CREATE OR REPLACE VIEW to rename the columns