Changing data type must recreate all views?

From: "Yudie" <yudie(at)axiontech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Changing data type must recreate all views?
Date: 2003-08-13 16:51:20
Message-ID: 000b01c361bb$1fcc57d0$8401a8c0@yudie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-08-13 17:10:02 Re: How to optimize this query ?
Previous Message Jonathan Gardner 2003-08-13 16:20:06 Re: Order of triggers - totally lost