How to change column type in PostgreSQL 7.1.2 - Mailing list pgsql-general

From Vilson farias
Subject How to change column type in PostgreSQL 7.1.2
Date
Msg-id 004b01c330e1$aff66040$98a0a8c0@dgtac
Whole thread Raw
List pgsql-general
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

Dígitro Tecnologia Ltda - www.digitro.com.br
APC - Customer Oriented Applications
E-mail: vilson.farias@digitro.com.br
Tel.: +55 48 281 7158
ICQ 11866179


pgsql-general by date:

Previous
From: Justin Clift
Date:
Subject: Re: [HACKERS] SAP and MySQL ... [and Benchmark]
Next
From: Martin Marques
Date:
Subject: Re: Postgres performance comments from a MySQL user