modifying VARCHAR max length

From: Divya Jain <dijain(at)cisco(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: modifying VARCHAR max length
Date: 2003-05-28 18:44:30
Message-ID: 4.3.2.7.2.20030528114408.03235970@mira-sjc5-5.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm running Postgres 7.2.4. A VARCHAR column in my schema needs to be longer than the currently defined max length. What is the best way to achieve this without adding a new column with the correct VARCHAR length ?

One way I figured is to modify the pg_attribute table and set atttypmod to the correct value. Just want to know if there is any risk involved in doing this.
Thanks
Divya

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-05-28 18:58:44 Re: problem delete record error:heap_mark4update
Previous Message valerian 2003-05-28 18:36:10 CURRENT_DATE and CURRENT_TIME return incorrect values