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_attrib
"Dan Wilson" <[EMAIL PROTECTED]> writes:
> I want to alter the length of a column without dumping an re-creating the
> table.
What kind of column?
Offhand I think that hacking atttypmod would be safe for varchar(n)
but not char(n). BTW, you might need to start a new backend session
to see the e
I want to alter the length of a column without dumping an re-creating the
table.
I found this method in the archives and was just wondering if there are any
side effects...
-
update pg_attribute set atttypmod = [column_oid] where attname =
'[column_name]' where attrel
