Re: [GENERAL] Table definition changes when a row is dropped and

2006-12-05 Thread Scott Marlowe
On Tue, 2006-12-05 at 00:42, deep ... wrote: > Hi everyone, > > I have a java app using pgsql 7.3 on unix platform where the latest > version of the app updates the width of a row in a table as a part of > upgrade. Since there is no straightforward 'modify' clause in > Postgresql 7.3, we're using

[GENERAL] Table definition changes when a row is dropped and recreated

2006-12-05 Thread deep ...
Hi everyone, I have a java app using pgsql 7.3 on unix platform where the latest version of the app updates the width of a row in a table as a part of upgrade. Since there is no straightforward 'modify' clause in Postgresql 7.3, we're using alter table ... add new_column type (width); update ..