> The sticky thing is dropping a column. There are two options, and
> postgresql developers just can't make up their mind :P)
>
> a) keep old column data in database (wasted space, but fast)
> b) immediately 'compress' table, removing old data (slow, needs a
lot of
> space for compression)
>
> Opt
Unfortunately, some of the head aches I have been encountering require me to
be able to do such oddities (example: my money column type not working with
the pgsql odbc driver). It's not just limited to a varchar to int
conversion that was just an example. There's a bunch of things that I need
to
On Mon, 24 Sep 2001, Rod Taylor wrote:
> Out of curiosity how was option a) implemented? I could envision
> supporting multiple versions of a tuple style to be found within a
> table (each described in pg_attribute). Gradually these would be
> upgraded through normal use.
Check the archives (lo
On Mon, 24 Sep 2001, mlw wrote:
> To be honest I am very surprised that MS SQL supports that, but then
> again Microsoft is so used to doing everything so utterly wrong, they
> have to design all their products with the ability to support
> fundamental design error corrections on the fly.
>
> I
"Gowey, Geoffrey" wrote:
>
> >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
"Gowey, Geoffrey" wrote:
>
> One thought did just occur to me. It is at least theoretically possible to
> simplisticly migrate on column type to another by reading in the data and
> oid of the row into a struct, drop the column, create a new column with the
> correct data type, and populate. Th
"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?
create temptable
as select
>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
saying
"no, you can't".
Geoff
-Original Message-
From: Gowey, Geoffrey
Sent: Monday, September 24, 2001 10:53 AM
To: 'Alex Pilosov'; Gowey, Geoffrey
Cc: [EMAIL PROTECTED]
Subject: RE: [HACKERS] Changing data types
>This is not for -hackers.
How so?
>A
This is not for -hackers.
And the answer is "no, you can't". Recreate the table with correct types
and insert the old values into it.
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
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?
Geoff
---(end of broadcast)---
11 matches
Mail list logo
