Re: change column data type from smallint to integer

Alvaro Herrera wrote:
> On Thu, Sep 08, 2005 at 04:22:07AM +0200, pobox(at)verysmall(dot)org 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 = old, then drop old and
>> rename new like old [1].
>>
>> Could somebody confirm if this is really the best way and if it is
>> stable in respect to indexes, RI, triggers, stored procedures, etc.
>
> In 8.0, you can alter the type directly in the table. In releases
> before 8.0, you have found the right workaround.

Thank you, Alvaro, for the confirmation!