I recommend reading Tom Lane's talk "Concurrency Issues" at OSCON2002.
This will answer all questions and some more.
Best regards,
Hans
Savita wrote:
>--------------880B7BB5722DEBFDA92AF2C3
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hi All,
>
>I have a question related to postgres.I have an application which is transferring data from MSSQL to Postgres at some
regularinterval.
>
>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)
>----------------------------------------------------
>
>
>--------------880B7BB5722DEBFDA92AF2C3
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>Hi All,
><p>I have a question related to postgres.I have an application which is
>transferring data from MSSQL to Postgres at some regular interval.
><p>I had around 20,000 data in MSSQL which should be transferred to postgres.
><br>After transferring around 12000 data I got a error message
><br><b><font color="#3333FF">ERROR: deadlock detected</font></b>
><br><font color="#000000">And after that data transfer has stopped.</font><font color="#000000"></font>
><p><font color="#000000">How to avoid this error and what is the reason
>for this error.</font>
><br>--
><br>Best Regards
><br>- Savita
><br>----------------------------------------------------
><br>Hewlett Packard (India)
><br>+91 80 2051288 (Phone)
><br>847 1288 (HP Telnet)
><br>----------------------------------------------------
><br> </html>
>
>--------------880B7BB5722DEBFDA92AF2C3--
>
>
>
--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
<http://cluster.postgresql.at>, www.cybertec.at
<http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>