Re: Changing size of varchar field - Mailing list pgsql-general

From dan radom
Subject Re: Changing size of varchar field
Date
Msg-id 20021025011001.GB2612@lunar.radom.org
Whole thread Raw
In response to Changing size of varchar field  (cg <chris.gamble@cpbinc.com>)
List pgsql-general
* cg (chris.gamble@cpbinc.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

pgsql-general by date:

Previous
From: "John"
Date:
Subject: Error on import
Next
From: Tom Lane
Date:
Subject: Re: Error on import