Increasing the length of a varchar domain - Mailing list pgsql-general

From Rich Doughty
Subject Increasing the length of a varchar domain
Date
Msg-id 20050131122609.GA20159@europa.cosmos.opusvl.com
Whole thread Raw
List 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

pgsql-general by date:

Previous
From: phil campaigne
Date:
Subject: Error Message
Next
From: Shawn Harrison
Date:
Subject: Re: Allowing update of column only from trigger