Increasing the length of a varchar domain

From: Rich Doughty <rich(at)opusvl(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Increasing the length of a varchar domain
Date: 2005-01-31 12:26:09
Message-ID: 20050131122609.GA20159@europa.cosmos.opusvl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I need to increase the length of one of my domains from 16 -> 20 characters.
How wise/unwise would it be for me to issue an

UPDATE pg_type SET typtypmod = '<newlength + 4>' WHERE typname = '<domain name>';

command to achieve this. I'd prefer not to dump/reload the database. I
remember seeing a thread on this a few months back, but can't seem to find
it anymore.

PG version 7.4.2 (I know, needs updating...)

Any advice?

- Rich Doughty

Browse pgsql-general by date

  From Date Subject
Next Message John Sidney-Woollett 2005-01-31 12:33:30 Re: Dynamic SQL
Previous Message Mark Battersby 2005-01-31 12:18:38 Dynamic SQL