Postgres Pro
Downloads
Home   >   mailing lists

modifying VARCHAR max length - Mailing list pgsql-general

From Divya Jain
Subject modifying VARCHAR max length
Date
Msg-id 4.3.2.7.2.20030528112658.03049288@mira-sjc5-5.cisco.com
Whole thread Raw
List pgsql-general
Tree view 
I'm running Postgres 7.2.4. A VARCHAR column in my schema needs to be longer than the currently defined max length.
Whatis 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
thereis any risk involved in doing this. 
Thanks
Divya

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Lock table
Next
From: valerian
Date:
Subject: CURRENT_DATE and CURRENT_TIME return incorrect values