Changing data type must recreate all views? - Mailing list pgsql-sql

From Yudie
Subject Changing data type must recreate all views?
Date
Msg-id 000b01c361bb$1fcc57d0$8401a8c0@yudie
Whole thread Raw
In response to Order of triggers - totally lost  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Responses Re: Changing data type must recreate all views?  (Peter Eisentraut <peter_e@gmx.net>)
List 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 by date:

Previous
From: Jonathan Gardner
Date:
Subject: Re: Order of triggers - totally lost
Next
From: Stephan Szabo
Date:
Subject: Re: How to optimize this query ?