Thread: smallint to bigint

smallint to bigint

From
Mickaël Jouanne
Date:
Hello !

I have a table with :

 prixandern | smallint     |
 prixcvdern | smallint     |

but i want to change smallint to bigint without droping the table.

How can i make that ?

thx for answers.

--

Mickaël JOUANNE
Webmaster / Developpeur / Support Technique

APR-Job & www.jobscout24.fr  - Meet your future
_______________________________________________

HumanLine France SAS     Tel: +33 1 42 44 40 73
32, rue Pierret          Fax: +33 1 49 26 09 76
92200 Neuilly            m.jouanne@humanline.fr

Re: smallint to bigint

From
Peter Eisentraut
Date:
Mickaël Jouanne writes:

> but i want to change smallint to bigint without droping the table.

Can't do that.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


Re: smallint to bigint

From
Stephan Szabo
Date:
About all you can do is make a new table with the structure
you want and use insert into to copy the data and then alter
table to rename the tables in place.  (One note though, if
you're trying to go from int2 to int8 it's kind of unhappy
for one step, you'll need to promote to int4 and then to int8
in the select).

Stephan Szabo
sszabo@bigpanda.com

On Tue, 14 Nov 2000, [iso-8859-1] Micka�l Jouanne wrote:

> Hello !
>
> I have a table with :
>
>  prixandern | smallint     |
>  prixcvdern | smallint     |
>
> but i want to change smallint to bigint without droping the table.
>
> How can i make that ?