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 46313D1B8AC for ; Tue, 19 Aug 2003 04:53:56 -0300 (ADT) 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 95363-02 for ; Tue, 19 Aug 2003 04:53:47 -0300 (ADT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id 85D30D1B8A3 for ; Tue, 19 Aug 2003 04:53:41 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 958EB559A3; Tue, 19 Aug 2003 09:53:35 +0200 (CEST) Received: from www.credativ.de (p50925706.dip.t-dialin.net [80.146.87.6]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 4DF7D5599E; Tue, 19 Aug 2003 09:53:35 +0200 (CEST) Received: from [172.26.14.239] (unknown [172.26.14.239]) (using TLSv1 with cipher EDH-RSA-DES-CBC3-SHA (168/168 bits)) (No client certificate requested) by www.credativ.de (Postfix) with ESMTP id 7056D1C00BF; Tue, 19 Aug 2003 09:51:41 +0200 (CEST) Date: Tue, 19 Aug 2003 09:53:34 +0200 (CEST) From: Peter Eisentraut X-X-Sender: peter@krusty.localdomain To: Yudie Cc: pgsql-sql@postgresql.org Subject: Re: Changing data type must recreate all views? In-Reply-To: <000b01c361bb$1fcc57d0$8401a8c0@yudie> Message-ID: References: <001001c36183$4f636570$0403a8c0@fejleszt4> <200308130754.32211.jgardner@jonathangardner.net> <003e01c361b1$37d02780$0403a8c0@fejleszt4> <200308130920.07619.jgardner@jonathangardner.net> <000b01c361bb$1fcc57d0$8401a8c0@yudie> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by AMaViS X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/213 X-Sequence-Number: 14829 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@gmx.net