Question about DEADLOCK

From: Savita <savita(at)india(dot)hp(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Question about DEADLOCK
Date: 2002-11-22 06:24:00
Message-ID: 3DDDCD80.EF942881@india.hp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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)
----------------------------------------------------

In response to

  • Hot Backup at 2002-10-07 17:21:06 from Sandeep Chadha

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Egyud Csaba 2002-11-22 06:35:56 Re: Welcom & a problem
Previous Message Egyud Csaba 2002-11-22 04:57:33 Re: Welcom & a problem

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephan Szabo 2002-11-22 07:04:52 Re: Question about DEADLOCK
Previous Message Bruce Momjian 2002-11-22 05:49:36 Re: Fw: Missing file from CVS?