I've used that method without any problems. I had to experiment a bit by
creating test tables with different length columns to see what to set
atttypmod to, because I didn't really know what the value meant! Seemed to
work ok though...
Tamsin
>
> -----------------------------
> update pg_attribute set atttypmod = [column_oid] where attname =
> '[column_name]' where attrelid = (select oid from pg_class where relname =
> '[table_name]');
> -----------------------------
>
> Will doing this cause any problems?
>
> -Dan
>