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