Postgres Pro
Downloads
Home   >   mailing lists

Re: Deadlock with one table - PostgreSQL is doing it right - Mailing list pgsql-general

From Hans Schou
Subject Re: Deadlock with one table - PostgreSQL is doing it right
Date
Msg-id CAApBw36dW+aD-wm96Z5A5p=Nx3sNHknaJ40E-LMWmtToBJW10A@mail.gmail.com
Whole thread Raw
In response to Re: Deadlock with one table - PostgreSQL is doing it right  ("Rakesh Kumar" <rakeshkumar464@mail.com>)
List pgsql-general
Tree view
2017-12-21 21:50 GMT+01:00 Rakesh Kumar <rakeshkumar464@mail.com>:
whenever SQLERROR EXIT ROLLBACK

Thanks. You are absolutely right.
After starting with:
   WHENEVER SQLERROR EXIT ROLLBACK
the process getting the deadlock will exit to command prompt (with %ERRORLEVEL% = 0).

So what actually found out was that Oracle has some strange combinations of default values regarding
1. AUTOCOMMIT = 0
2. Don't exit/rollback on deadlock


pgsql-general by date:

Previous
From: Ken Tanzer
Date:
Subject: Re: Intersection or zero-column queries
Next
From: Ertan Küçükoğlu
Date:
Subject: Character with byte sequence error