Re: [SQL] Changing data type must recreate all views?

2003-08-19 Thread Peter Eisentraut
Yudie writes: > 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 vi

[SQL] Changing data type must recreate all views?

2003-08-14 Thread Yudie
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? Thank