Changing the size of a varchar field

[Eric Ridge <ebr@tcdi.com>]

Using PG 7.3.x, how stupid is this:

	UPDATE pg_attribute SET atttypmod=<new size + 4> WHERE ....;

I had to do this on a database, and surprisingly it seems to have 
worked just fine.  The columns accept a larger value, the existing 
values are still intact, and I've seen no other strange errors...

Am I living dangerously, or is this an "okay" thing to do?

eric


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

              http://archives.postgresql.org