| From: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
|---|---|
| To: | Divya Jain <dijain(at)cisco(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: modifying system table |
| Date: | 2003-05-29 14:35:13 |
| Message-ID: | 1054218913.5914.2373.camel@camel |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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. 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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Lee | 2003-05-29 14:48:06 | Re: Error starting backend |
| Previous Message | Robert Treat | 2003-05-29 14:33:41 | Re: Identifying databases. |