BEGIN PGP SIGNED MESSAGE-
> Hash: RIPEMD160
>
> Justin Julicher asked:
> > We need to widen a column on a table with millions of rows and the only
> way
> > to do this currently is to migrate the data from one column to another
> with
> > a script and trigger.
>
>
Psql Version: 8.4
Hi,
We need to widen a column on a table with millions of rows and the only way
to do this currently is to migrate the data from one column to another with
a script and trigger.
I know how to do this via an update to pg_attribute which would incur the
table scan penalty but