X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8487DD1B58A for ; Wed, 13 Aug 2003 16:48:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 36835-05 for ; Wed, 13 Aug 2003 13:46:46 -0300 (ADT) Received: from axiontctxus1.axiontech.com (unknown [216.52.172.78]) by svr1.postgresql.org (Postfix) with SMTP id 4D6BAD1B53A for ; Wed, 13 Aug 2003 13:48:11 -0300 (ADT) Received: (qmail 12168 invoked by uid 104); 13 Aug 2003 16:46:39 -0000 Received: from yudie@axiontech.com by axiontctxus1 with network-box scanner-1.10 (received+scanned in 4.572578 secs); 13 Aug 2003 16:46:39 -0000 X-Scanned-By-axiontctxus1: Virus scan performed by network-box (www.network-box.com) X-Scanned-By-axiontctxus1: Scanner file id is axiontctxus1106079319547712153 X-Scanned-By-axiontctxus1: No known viruses found in message (received+scanned in 4.572578 secs) X-Scanned-By-axiontctxus1: Spam-Check-Result: No, hits=-113.1 required=7.0 tests=BAYES_01, REFERENCES, USER_IN_WHITELIST autolearn=ham version=2.53 Received: from mail.axiontech.com (HELO axiontech.com) (216.52.172.74) by 216.52.172.68 with SMTP; 13 Aug 2003 16:46:35 -0000 Received: (qmail 3070 invoked from network); 13 Aug 2003 16:47:40 -0000 Received: from pc-00132 (HELO yudie) (192.168.1.132) by mail.axiontech.com (192.168.1.6) with SMTP; 13 Aug 2003 16:47:40 -0000 Message-ID: <000b01c361bb$1fcc57d0$8401a8c0@yudie> From: "Yudie" To: References: <001001c36183$4f636570$0403a8c0@fejleszt4> <200308130754.32211.jgardner@jonathangardner.net> <003e01c361b1$37d02780$0403a8c0@fejleszt4> <200308130920.07619.jgardner@jonathangardner.net> Subject: Changing data type must recreate all views? Date: Wed, 13 Aug 2003 11:51:20 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/143 X-Sequence-Number: 14759 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