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
rename_view_column_v1.patch
Description: Binary data
