Re: change column length, is it that hard?

Ron Arts <ron(dot)arts(at)neonova(dot)nl> writes:
> One of the tables contains a field username character varying(16)
> that needs to become varying(40), so just a little longer.

The traditional solution to this is to hack the pg_attribute.atttypmod
value for the column. I *strongly* recommend practicing on a scratch
database before you do this for real --- wrapping the whole thing in a
transaction so you can roll it back is a good idea, too.

> NOTICE: rule _RETURN on view ox_deps depends on table contact column username
> NOTICE: view ox_deps depends on rule _RETURN on view ox_deps

If you've got dependent views then you need to think about whether their
output column types need to change too.

regards, tom lane