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 views and triggers?
Not really.
Perhaps it will be easier if you do a dump of the affected objects, edit
the dump file, and reload.
--
Peter Eisentraut peter_e(at)gmx(dot)net