Re: Changing size of varchar field

From: dan radom <dan(at)radom(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Changing size of varchar field
Date: 2002-10-25 01:10:01
Message-ID: 20021025011001.GB2612@lunar.radom.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

* cg (chris(dot)gamble(at)cpbinc(dot)com) wrote:
> I recently saw on this list a way to change the length of a varchar
> field using the pg_atttypemod table. My question is: is this safe on a
> database with data? Are there any drawbacks to doing this and is there
> any plan to make this a standard usable feature?
>

i think with any modification you should always pg_dump the database. if
all hell breaks lose you can always go back to the point you were at
before the change.

dan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message cg 2002-10-25 01:40:23 Changing size of varchar field
Previous Message John 2002-10-25 00:50:05 Error on import