From: Yudie <yudie@axiontech.com>
To: pgsql-sql@postgresql.org
Subject: Changing data type must recreate all views?
Date: Wed, 13 Aug 2003 11:51:20 -0500
Message-ID: <000b01c361bb$1fcc57d0$8401a8c0@yudie> (raw)
References: <001001c36183$4f636570$0403a8c0@fejleszt4>
<200308130754.32211.jgardner@jonathangardner.net>
<003e01c361b1$37d02780$0403a8c0@fejleszt4>
<200308130920.07619.jgardner@jonathangardner.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: yudie@axiontech.com
Subject: Re: Changing data type must recreate all views?
In-Reply-To: <000b01c361bb$1fcc57d0$8401a8c0@yudie>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox