I've run into a bit of a problem, I have a varchar(6) field that I now need to
have as a varchar(12).
I am relatively new to postgres and am unsure how best to do this. What I
would like to do is alter the meta-data directly. Change the value of
atttypmod in pg_attribute directly. Initial tests look good, however I am
unsure how safe this is. Or what else needs to be done? does it need to be
I have looked at the sections on renaming/changing columns, though this is
more a solid an option, I am dealing with millions of records and the
downtime for the backfill is not acceptable.
I found some old post in here hinting at doing this, however the links in them
are now dead.
Givex - http://www.givex.com/
Derik Barclay <dbarclay(at)givex(dot)com>, Systems Software Engineer
+1 416 350 9660
+1 416 250 9661 (fax)
pgsql-general by date
|Next:||From: Greg Stark||Date: 2004-12-23 22:22:24|
|Subject: Re: select as|
|Previous:||From: Alvaro Herrera||Date: 2004-12-23 22:11:44|
|Subject: Re: Very slow stored proc|