Re: Deadlock with one table - PostgreSQL is doing it right

[Hans Schou <hans.schou@xxxxxxxxx>]

2017-12-21 21:50 GMT+01:00 Rakesh Kumar <rakeshkumar464@xxxxxxxx>:

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