Hello all, This is a copy from Admin explaining how to change variable lenght:
>If you're willing to do a little magic to the system tables (and you have >a recent backup :) ). You can change the atttypmod of the column in >question from 14 to 24. This really only works on variable length items >and only to expand them, but... > >You pretty much need to do a sequence like: >select oid, relname from pg_class where relname='<tablename>'; >update pg_attribute set atttypmod=24 where attrelid=<oid from previous> > and attname='<attributename>' >in a superuser account. Best regards, Jean-Michel POURE
