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
The same issue is with ALTER FOREIGN TABLE
# ALTER FOREIGN TABLE ft RENAME COLUMN a to t;
ALTER TABLE
# ALTER MATERIALIZED VIEW mv RENAME COLUMN a to r;
ALTER TABLE
Attached patch fixes that for ALTER VIEW , ALTER MATERIALIZED VIEW and ALTER FOREIGN TABLE
# ALTER MATERIALIZED VIEW mv RENAME COLUMN a to r;