On Thu, Oct 31, 2019 at 6:56 PM Tom Lane <t...@sss.pgh.pa.us> wrote:

> Fujii Masao <masao.fu...@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;

ALTER MATERIALIZED VIEW


# ALTER FOREIGN TABLE ft RENAME COLUMN a to t;

ALTER FOREIGN TABLE


-- 
Ibrar Ahmed

Attachment: 001_alter_tag_ibrar_v1.patch
Description: Binary data

Reply via email to