Re: modifying system table

It's generally considered safe, but search the archives for the proper
formula so you get the results your hoping for. (IIRC its length + 4,
but I'd search just to be sure).

Robert Treat

On Wed, 2003-05-28 at 17:15, Divya Jain wrote:
> 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
>