Changing data type must recreate all views?

Поиск
Список
Период
Сортировка
От Yudie
Тема Changing data type must recreate all views?
Дата
Msg-id 000b01c361bb$1fcc57d0$8401a8c0@yudie
обсуждение исходный текст
Ответ на Order of triggers - totally lost  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Ответы Re: Changing data type must recreate all views?
Список pgsql-sql
I need to change column data type from integer to float8
That mean to droping table and recreate a new one and can lost the original
object id.
Do i need to recreate all views and triggers that relate to that table?
if that so, is there anyway to do that without touching views and triggers?


Thanks,
yudie





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

Предыдущее
От: Jonathan Gardner
Дата:
Сообщение: Re: Order of triggers - totally lost
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: How to optimize this query ?