Re: altering a column - Mailing list pgsql-general

From Tom Lane
Subject Re: altering a column
Date
Msg-id 21924.1073280744@sss.pgh.pa.us
Whole thread Raw
In response to altering a column  (treat00@yahoo.com (Thomas Reat))
List pgsql-general
treat00@yahoo.com (Thomas Reat) writes:
> I need to change a varchar(32) to varchar(1024). It is a primary key
> that many tables reference. How do I do this without reloading the
> entire database?

When your back is to the wall, you can hack the pg_attribute.atttypmod
for the column (this is sufficient in this particular case).  See
archives for discussion, and please heed the advice to experiment in
a scratch database.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: GetLastInsertID ?
Next
From: Robert Treat
Date:
Subject: Re: Is my MySQL Gaining ?