Horton

Re: Changing data types

Geoffrey J. Gowey <ggowey@rxhope.com>

View thread View on postgr.es
From: "Gowey, Geoffrey" <ggowey@rxhope.com>
To: "'Alex Pilosov'" <alex@pilosoft.com>, "Gowey, Geoffrey" <ggowey@rxhope.com>
Cc: pgsql-hackers@postgresql.org
Date: 2001-09-24T14:53:02Z
Lists: pgsql-hackers 
>This is not for -hackers. 

How so?

>And the answer is "no, you can't". Recreate the table with correct types
>and insert the old values into it.

You're kidding me, right?  *prepares to gargle* MS Sql server can.  Surely
we can implement this feature or aren't we aiming to go head to head with
commercial rdbms'?

>>On Mon, 24 Sep 2001, Gowey, Geoffrey wrote:

>> I posted this in my last message, but have not heard anything yet so I'm
>> wondering if it was overlooked.  I need to know how to change a column
from
>> being say a varchar(9) to an integer.  Does anyone know how to change the
>> data type?