X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 644CAD1B533 for ; Mon, 27 Oct 2003 19:03:57 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 06382-08 for ; Mon, 27 Oct 2003 15:03:27 -0400 (AST) Received: from serwer.skawsoft.com.pl (serwer.skawsoft.com.pl [213.25.37.66]) by svr1.postgresql.org (Postfix) with ESMTP id E7E50D1B4FE for ; Mon, 27 Oct 2003 15:03:25 -0400 (AST) Received: from klaster.net (core-1.citynet.pl [80.48.135.69]) by serwer.skawsoft.com.pl (Postfix) with ESMTP id 35B2B2B3CC; Mon, 27 Oct 2003 20:01:46 +0100 (CET) Message-ID: <3F9D6B8B.1050303@klaster.net> Date: Mon, 27 Oct 2003 20:01:31 +0100 From: Tomasz Myrta User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; pl-PL; rv:1.5) Gecko/20030916 X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: btober@seaworthysys.com Cc: mohan@physics.gmu.edu, pgsql-sql@postgresql.org Subject: Re: URGENT!!! changing Column size References: <64184.138.88.163.115.1067274631.squirrel@physics.gmu.edu> <3F9D59FC.8010407@klaster.net> <1608.192.168.123.2.1067279639.squirrel@$HOSTNAME> In-Reply-To: <1608.192.168.123.2.1067279639.squirrel@$HOSTNAME> Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/348 X-Sequence-Number: 15748 Dnia 2003-10-27 19:33, Użytkownik btober@seaworthysys.com napisał: > I've seen these sets of steps suggested in response to other such > inquires, but doesn't this break views on the associated table, or may > just not work because if a view dependency exists? It would be the second case (it won't work at all). You can use "cascade" when dropping column. After this you need to recreate views dropped together with a column. Regards, Tomasz Myrta