Re: Insert query hangs

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(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of M Tarkeshwar Rao
Sent: 09 July 2014 14:49
To: pgsql-hackers-owner(at)postgresql(dot)org; pgsql-hackers(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
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(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general