[GENERAL] Postgresql reindex hangs when table is being updated

2006-09-27 Thread deep ...
Hi all, I'm running a web application supported by postgresql 7.4 on an unix system. The management part of application requires reindexing of tables. I see that whenever reindexing runs with the while the table is getting updated/inserted into, reindexing hangs. I understand this is because rein

[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 ..