X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 413499FB26A for ; Thu, 3 Aug 2006 16:40:36 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 31704-08 for ; Thu, 3 Aug 2006 19:40:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 1BD649FB259 for ; Thu, 3 Aug 2006 16:40:27 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k73JePWv024206; Thu, 3 Aug 2006 15:40:25 -0400 (EDT) To: "Andrew Hammond" cc: pgsql-sql@postgresql.org Subject: Re: alter column type from boolean to char with default In-reply-to: <1154630971.819812.304930@p79g2000cwp.googlegroups.com> References: <684362e10608020546t16e6d3e8nf6756abd15a21a68@mail.gmail.com> <15041.1154524770@sss.pgh.pa.us> <1154526983.29712.223.camel@home> <18063.1154536619@sss.pgh.pa.us> <1154630971.819812.304930@p79g2000cwp.googlegroups.com> Comments: In-reply-to "Andrew Hammond" message dated "03 Aug 2006 11:49:31 -0700" Date: Thu, 03 Aug 2006 15:40:25 -0400 Message-ID: <24205.1154634025@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/32 X-Sequence-Number: 25990 "Andrew Hammond" writes: > Alternatively, you already have the USING clause to tell you how to > alter the data. How about using it to alter the default as well? The reasons not to do that are already set forth in the ALTER TABLE man page. regards, tom lane