Re: [GENERAL] Updating pg_attribute to widen column

2012-11-29 Thread Justin Julicher
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. > >

[GENERAL] Updating pg_attribute to widen column

2012-11-29 Thread Justin Julicher
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