Change view definition - do not have to drop it

[Emi Lu <emilu@xxxxxxxxxxxxxxxxx>]

Original view1 (col1 bpchar, col2 varchar).

Now I need update view1 definition to
create or replace view view1 as select col1, col2 from new_table;

However, col1 in new_table is not bpchar. This gives me headache! There 
are tens of dependent views based on view1, so I cannot just drop view1 
and recreate it.

How I can redefine view1 without dropping it and recreate it?

Thanks a lot!

--
Lu Ying


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general