| From: | M Tarkeshwar Rao <m(dot)tarkeshwar(dot)rao(at)ericsson(dot)com> |
|---|---|
| To: | "pgsql-hackers-owner(at)postgresql(dot)org" <pgsql-hackers-owner(at)postgresql(dot)org>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Insert query hangs |
| Date: | 2014-07-09 09:18:40 |
| Message-ID: | 1C16813DAFF3E44B939586605D40E9F01165FB75@ESESSMB107.ericsson.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ravi Kiran | 2014-07-09 10:18:09 | gdb debugging with postgres |
| Previous Message | Gavin Flower | 2014-07-09 02:04:51 | Re: Random-looking primary keys in the range 100000..999999 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jov | 2014-07-09 10:27:39 | Re: change alter user to be a true alias for alter role |
| Previous Message | Peter Geoghegan | 2014-07-09 06:56:59 | Re: Doing better at HINTing an appropriate column within errorMissingColumn() |