"Nick Fankhauser" <nickf(at)ontko(dot)com> writes:
> The update to change a varchar(10) field to varchar(40) looked like this:
> update pg_attribute set atttypmod = 44
> where attrelid = ( select oid from pg_class where relname = 'test' )
> and attname = 'oldtest' ;
> Is this a smart thing to do?
Yup, that's the standard hack.
regards, tom lane