Postgres Pro
Downloads
Home   >   mailing lists

Question about DEADLOCK - Mailing list pgsql-general

From Savita
Subject Question about DEADLOCK
Date
Msg-id 3DDDCD80.EF942881@india.hp.com
Whole thread Raw
In response to Hot Backup  ("Sandeep Chadha" <sandeep@newnetco.com>)
Responses Re: Question about DEADLOCK  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Tree view
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)
----------------------------------------------------
 

pgsql-general by date:

Previous
From: Brian Minton
Date:
Subject: Re: Changing the type of a column in an already populated database.
Next
From: Stephan Szabo
Date:
Subject: Re: Question about DEADLOCK