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

[Hans Schou <hans.schou@xxxxxxxxx>]

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

Could it be that the tool you are using in Oracle is doing commit while exiting out due to Deadlock, because there is no explicit rollback.

The tool Im using is "sqlplus". By default you are always in a transaction and auto-commit only occur on exit. 

Please note that Oracle leave the table with a half transaction, i.e. only one row is updated.