Re: How to change column type in PostgreSQL 7.1.2

drop key, Add a column, fill from old column, delete old column, rename
new column to old name, add key.

Watch out for indexes, functions, views, and especially referential
constraints against that column. This is one reason why I always use a
surrogate key.

this Will only work if you have unique rows.

Vilson farias wrote:
>
> Greetings,
>
> I'm wondering if there is a way to change a column type in PostgreSQL
> 7.1.2 without reconstruction of table + pg_dump/restore of table data
> (machine can't be stopped for a long time). I have a table with a integer
> column and I would like to change it to varchar(20). One more thing, this
> collumn belongs to a composed primary key. Is it possible?
>
> Best regards
>
> ----------------------------------------------------------------------------
> ----
> Jos Vilson de Mello de Farias
> Software Engineer
>
> Dgitro Tecnologia Ltda - www.digitro.com.br
> APC - Customer Oriented Applications
> E-mail: vilson(dot)farias(at)digitro(dot)com(dot)br
> Tel.: +55 48 281 7158
> ICQ 11866179
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org