Skip site navigation (1) Skip section navigation (2)

Re: Making a varchar bigger

From: Derik Barclay <dbarclay(at)givex(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Making a varchar bigger
Date: 2004-12-30 21:59:06
Message-ID: 200412301659.06714.dbarclay@givex.com (view raw or flat)
Thread:
Lists: pgsql-general
Specificaly I am looking at executing something like this:

UPDATE pg_attribute SET atttypmod = 16 where attname = 'x' AND attrelid = 
(select pg_class.oid from pg_class where relname = 'mytable');

On December 23, 2004 05:13 pm, Derik Barclay wrote:
> Hello Group,
>
> 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
> re-indexed?
>
> 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)

In response to

Responses

pgsql-general by date

Next:From: Thomas Braad ToftDate: 2004-12-30 22:16:59
Subject: Recursive update
Previous:From: Tom LaneDate: 2004-12-30 21:48:05
Subject: Re: postgresql 8.0 rc1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group