Postgres Pro
Downloads
Home   >   mailing lists

Re: alter column type from boolean to char with default - Mailing list pgsql-sql

From Tom Lane
Subject Re: alter column type from boolean to char with default
Date
Msg-id 24205.1154634025@sss.pgh.pa.us
Whole thread Raw
In response to Re: alter column type from boolean to char with default  ("Andrew Hammond" <andrew.george.hammond@gmail.com>)
List pgsql-sql
Tree view 
"Andrew Hammond" <andrew.george.hammond@gmail.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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error: out of memory in create table as
Next
From: "David Garamond"
Date:
Subject: autoupdating mtime column