Increasing the length of a varchar domain

Rich Doughty <rich@xxxxxxxxxx> · Mon, 31 Jan 2005 12:26:09 +0000

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org