X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 26AED329CA4 for ; Wed, 8 Sep 2004 18:20:38 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61696-02 for ; Wed, 8 Sep 2004 17:20:28 +0000 (GMT) Received: from mpls-qmqp-01.inet.qwest.net (mpls-qmqp-01.inet.qwest.net [63.231.195.112]) by svr1.postgresql.org (Postfix) with SMTP id CB5BD329D95 for ; Wed, 8 Sep 2004 18:20:28 +0100 (BST) Received: (qmail 4109 invoked by uid 0); 8 Sep 2004 17:20:26 -0000 Received: from unknown (63.231.195.9) by mpls-qmqp-01.inet.qwest.net with QMQP; 8 Sep 2004 17:20:26 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-09.inet.qwest.net with SMTP; 8 Sep 2004 17:20:25 -0000 Date: Wed, 08 Sep 2004 11:22:08 -0600 Message-Id: <1094664128.13944.16.camel@localhost.localdomain> From: "Scott Marlowe" To: "Warren Little" Cc: pgsql-admin@postgresql.org Subject: Re: changing the size of a varchar column In-Reply-To: <1094661942.2876.19.camel@localhost.localdomain> References: <1094661942.2876.19.camel@localhost.localdomain> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/78 X-Sequence-Number: 14781 On Wed, 2004-09-08 at 10:45, Warren Little wrote: > Hello, > Does pg7.4.x support resizing a varchar column > ie varchar(30) -> varchar(200) No, but some folks have done it by hacking the catalogs. not recommended, make a backup, etc... > If not does the feature in 8.0 relating to changing column types > support this? Yes.