Actually problem is in customer site in their production environment. They have their database MDB. In that db they have insert issue with one table. They shared the data folder with us. We past the same data folder in our local DB which has the same name MDB and reproduced the issue. After reproducing the issue we run pg_dump(with data) on corrupted table and restore it on another local db. After restoring in another db we tested the insert operation and found it is working fine. We analysed one more thing when we removed the unique index from the table it is working fine. Is there any issue in indexing? Is there any option to repair the table or its indexing? Regards Tarkeshwar -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of M Tarkeshwar Rao Sent: 09 July 2014 14:49 To: pgsql-hackers-owner@xxxxxxxxxxxxxx; pgsql-hackers@xxxxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx Subject: [GENERAL] Insert query hangs Hi all, We have a table in a database DB1 with name Test. We imported this database from another machine. When I fire insert statement it is going in the hang state. Then I created another table with same structure and with same data within it as in table Test. Then I fired the insert statement. It is working fine. I am not able find the reason for this. Can you please help me out on this. This scenario easily reproducible. I have a standalone system and postgresql 9.1 installed on it. Regards Tarkeshwar -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
