Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"
Date
Msg-id 16186.1572530177@sss.pgh.pa.us
Whole thread Raw
In response to The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: The command tag of "ALTER MATERIALIZED VIEW RENAME COLUMN"  (Ibrar Ahmed <ibrar.ahmad@gmail.com>)
List pgsql-hackers
Tree view 
Fujii Masao <masao.fujii@gmail.com> writes:
> ... 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?

Seems like an oversight.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Allow CREATE OR REPLACE VIEW to rename the columns
Next
From: Andrzej Barszcz
Date:
Subject: function calls optimization