Re: modifying system table - Mailing list pgsql-admin

From Robert Treat
Subject Re: modifying system table
Date
Msg-id 1054218913.5914.2373.camel@camel
Whole thread Raw
In response to modifying system table  (Divya Jain <dijain@cisco.com>)
List pgsql-admin
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
>




pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: Identifying databases.
Next
From: Jason Lee
Date:
Subject: Re: Error starting backend