Question about DEADLOCK

savita <savita@india.hp.com>

From: Savita <savita@india.hp.com>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2002-11-22T06:24:00Z
Lists: pgsql-hackers, pgsql-general
Hi All,

I have a question related to postgres.I have an application which is transferring data from MSSQL to Postgres at some regular interval.

I had around 20,000 data in MSSQL which should be transferred to postgres.
After transferring around 12000 data I got a error message
ERROR: deadlock detected
And after that data transfer has stopped.

How to avoid this error and what is the reason for this error.
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------