Insert query hangs

Поиск
Список
Период
Сортировка
От M Tarkeshwar Rao
Тема Insert query hangs
Дата
Msg-id 1C16813DAFF3E44B939586605D40E9F01165FB75@ESESSMB107.ericsson.se
обсуждение исходный текст
Ответы Re: Insert query hangs  (M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Gavin Flower
Дата:
Сообщение: Re: Random-looking primary keys in the range 100000..999999
Следующее
От: Ravi Kiran
Дата:
Сообщение: gdb debugging with postgres