Postgres Pro
Downloads
Home   >   mailing lists

Insert query hangs - Mailing list pgsql-general

From M Tarkeshwar Rao
Subject Insert query hangs
Date
Msg-id 1C16813DAFF3E44B939586605D40E9F01165FB75@ESESSMB107.ericsson.se
Whole thread Raw
Responses Re: Insert query hangs  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Random-looking primary keys in the range 100000..999999
Next
From: Ravi Kiran
Date:
Subject: gdb debugging with postgres