From wlittle@securitylending.com Wed Sep 8 16:45:48 2004 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-- From smarlowe@qwest.net Wed Sep 8 17:20:38 2004 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. From tsurkin@mail.jct.ac.il Wed Sep 8 21:35:01 2004 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 6EEB4329D04 for ; Wed, 8 Sep 2004 22:35:01 +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 47670-08 for ; Wed, 8 Sep 2004 21:34:57 +0000 (GMT) Received: from p-roman.jct.ac.il (p-roman.jct.ac.il [147.161.1.195]) by svr1.postgresql.org (Postfix) with ESMTP id 9AFA0329CFB for ; Wed, 8 Sep 2004 22:34:57 +0100 (BST) Received: from p-roman.jct.ac.il (localhost.localdomain [127.0.0.1]) by p-roman.jct.ac.il (8.12.11/8.12.11) with ESMTP id i88LYrgV001826; Thu, 9 Sep 2004 00:34:54 +0300 Received: from localhost (tsurkin@localhost) by p-roman.jct.ac.il (8.12.11/8.12.11/Submit) with ESMTP id i88LYr1T001822; Thu, 9 Sep 2004 00:34:53 +0300 X-Authentication-Warning: p-roman.jct.ac.il: tsurkin owned process doing -bs Date: Thu, 9 Sep 2004 00:34:52 +0300 (IDT) From: Tsirkin Evgeny X-X-Sender: tsurkin@p-roman.jct.ac.il To: Scott Marlowe Cc: Warren Little , pgsql-admin@postgresql.org Subject: Re: changing the size of a varchar column In-Reply-To: <1094664128.13944.16.camel@localhost.localdomain> Message-ID: References: <1094661942.2876.19.camel@localhost.localdomain> <1094664128.13944.16.camel@localhost.localdomain> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_RFCI X-Spam-Level: X-Archive-Number: 200409/81 X-Sequence-Number: 14784 Maybe you already know this but the solution is to create a new table with varchar(200) copy to it the data from the old one. Then drop the old one and recreate with varchar(200) then copy the data back from the tmp table. Again you probably know all this ,just trying to help... On Wed, 8 Sep 2004, Scott Marlowe wrote: > 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. > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html > -- Evgeny.