Change view definition - do not have to drop it

Поиск
Список
Период
Сортировка
От Emi Lu
Тема Change view definition - do not have to drop it
Дата
Msg-id 4A256BE6.7060107@encs.concordia.ca
обсуждение исходный текст
Ответы Re: Change view definition - do not have to drop it  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Browne
Дата:
Сообщение: Re: Schema, databse, or tables in different system folder
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Really out of memory?