Re: [GENERAL] Changing the size of a varchar field

2004-05-06 Thread Tom Lane
Eric Ridge <[EMAIL PROTECTED]> writes: > Using PG 7.3.x, how stupid is this: > UPDATE pg_attribute SET atttypmod= WHERE ; It'll work okay for a varchar column (not char) at least as far as the table itself is concerned. I think there are some issues for views referencing the column, pos

[GENERAL] Changing the size of a varchar field

2004-05-06 Thread Eric Ridge
Using PG 7.3.x, how stupid is this: UPDATE pg_attribute SET atttypmod= 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 l