| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Yudie <yudie(at)axiontech(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Changing data type must recreate all views? |
| Date: | 2003-08-19 07:53:34 |
| Message-ID: | Pine.LNX.4.56.0308190952400.4847@krusty.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| PostgreSQL : | Chidananda | 2003-08-19 08:32:41 | Configuring Problem on Solaris............ |
| Previous Message | Josh Berkus | 2003-08-19 04:36:39 | Re: Inheritance or no inheritance, there is a question |