Hi,

Currently CREATE OR REPLACE VIEW command fails if the column names
are changed. For example,

    =# CREATE VIEW test AS SELECT 0 AS a;
    =# CREATE OR REPLACE VIEW test AS SELECT 0 AS x;
    ERROR:  cannot change name of view column "a" to "x"

I'd like to propose the attached patch that allows CREATE OR REPLACE VIEW
to rename the view columns. Thought?

Regards,

-- 
Fujii Masao

Attachment: rename_view_column_v1.patch
Description: Binary data

Reply via email to