Skip site navigation (1) Skip section navigation (2)

Re: Changing data types

From: "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
To: "'Alex Pilosov'" <alex(at)pilosoft(dot)com>, "Gowey, Geoffrey" <ggowey(at)rxhope(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Changing data types
Date: 2001-09-24 14:53:02
Message-ID: E15F4B031E17D5118B18009027F67927DAF7@SERVER (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-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?

Responses

pgsql-hackers by date

Next:From: Gowey, GeoffreyDate: 2001-09-24 14:55:54
Subject: Re: Changing data types
Previous:From: Alex PilosovDate: 2001-09-24 14:40:23
Subject: Re: Changing data types

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2001-09-24 19:11:04
Subject: Alter project: client or server side?
Previous:From: Hiroshi InoueDate: 2001-09-24 08:18:20
Subject: Re: [ODBC] New driver options in 7.01.0007

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group