modifying system table

From: Divya Jain <dijain(at)cisco(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: modifying system table
Date: 2003-05-28 21:15:41
Message-ID: 4.3.2.7.2.20030528141514.03235970@mira-sjc5-5.cisco.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2003-05-28 22:12:51 Re: Crazy Triggers
Previous Message Kris Kiger 2003-05-28 21:05:20 Crazy Triggers