Re: alter column type from boolean to char with default

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: alter column type from boolean to char with default
Date: 2006-08-03 19:40:25
Message-ID: 24205.1154634025@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"Andrew Hammond" <andrew(dot)george(dot)hammond(at)gmail(dot)com> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jonathan Sinclair 2006-08-04 06:55:35
Previous Message Tom Lane 2006-08-03 19:37:07 Re: Error: out of memory in create table as