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 A7008329CE3 for ; Wed, 8 Sep 2004 17:45:48 +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 49833-04 for ; Wed, 8 Sep 2004 16:45:46 +0000 (GMT) Received: from mail.securitylending.com (mail.securitylending.com [65.90.55.70]) by svr1.postgresql.org (Postfix) with ESMTP id 5DEA4329CF8 for ; Wed, 8 Sep 2004 17:45:45 +0100 (BST) Received: from sharp by mail.securitylending.com; 08 Sep 2004 10:45:43 -0600 Subject: changing the size of a varchar column From: Warren Little To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-hpAl8KPGRt4GFNyiezP7" Message-Id: <1094661942.2876.19.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 08 Sep 2004 10:45:43 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.8 tagged_above=0.0 required=5.0 tests=HTML_30_40, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200409/75 X-Sequence-Number: 14778 --=-hpAl8KPGRt4GFNyiezP7 Content-Type: text/plain Content-Transfer-Encoding: 7bit Hello, Does pg7.4.x support resizing a varchar column ie varchar(30) -> varchar(200) If not does the feature in 8.0 relating to changing column types support this? thx -- Warren Little Senior Vice President Secondary Markets and IT Manager Security Lending Wholesale, LC www.securitylending.com Tel: 866-369-7763 Fax: 866-849-8079 --=-hpAl8KPGRt4GFNyiezP7 Content-Type: text/html; charset=utf-8 Hello,
Does pg7.4.x support resizing a varchar column
ie varchar(30) -> varchar(200)

If not does the feature in 8.0 relating to changing column types support this?

thx

-- 
Warren Little
Senior Vice President
Secondary Markets and IT Manager
Security Lending Wholesale, LC
www.securitylending.com
Tel: 866-369-7763
Fax: 866-849-8079
--=-hpAl8KPGRt4GFNyiezP7--