X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AADA1476347 for ; Tue, 15 Apr 2003 11:22:34 -0400 (EDT) Received: from jobs1.unisoftbg.com (unknown [194.12.229.207]) by postgresql.org (Postfix) with SMTP id E7A4E47633C for ; Tue, 15 Apr 2003 11:22:21 -0400 (EDT) Received: (qmail 876 invoked from network); 15 Apr 2003 16:56:39 -0000 Received: from unknown (HELO t1.unisoftbg.com) (194.12.229.193) by 0 with SMTP; 15 Apr 2003 16:56:39 -0000 Message-ID: <3E9C155B.7A694675@t1.unisoftbg.com> Date: Tue, 15 Apr 2003 16:21:15 +0200 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: changing column size and type. Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=2.1 required=5.0 tests=BAYES_20,RCVD_IN_DSBL,RCVD_IN_OSIRUSOFT_COM, TO_ADDRESS_EQ_REAL version=2.50 X-Spam-Level: ** X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/229 X-Sequence-Number: 12930 Hi, I am using pg 7.3.2. Is it possible to change: - column size ot existing table. - columnt size ( it is varchar basicaly). The problem is that the table have many freferences from and to it. many thanks, ivan.