Re: [GENERAL] change column data type from smallint to integer

2005-09-08 Thread [EMAIL PROTECTED]
Alvaro Herrera wrote: On Thu, Sep 08, 2005 at 04:22:07AM +0200, [EMAIL PROTECTED] wrote: Hi, we run 'out of space' in one of our columns which is smallint and we need to make it integer. I did some research and found out that the only way is to create a new column with integer data type, th

Re: [GENERAL] change column data type from smallint to integer

2005-09-07 Thread Alvaro Herrera
On Thu, Sep 08, 2005 at 04:22:07AM +0200, [EMAIL PROTECTED] wrote: Hi, > we run 'out of space' in one of our columns which is smallint and we > need to make it integer. > > I did some research and found out that the only way is to create a new > column with integer data type, then SET new = ol

[GENERAL] change column data type from smallint to integer

2005-09-07 Thread [EMAIL PROTECTED]
Hello, we run 'out of space' in one of our columns which is smallint and we need to make it integer. I did some research and found out that the only way is to create a new column with integer data type, then SET new = old, then drop old and rename new like old [1]. Could somebody confirm i