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 CAApBw34wEybSW73nZoOCrTy1KJrEeZR9OnM2SY7AnFoHtKmqcw@mail.gmail.com
Whole thread Raw
In response to Re: Deadlock with one table - PostgreSQL is doing it right  ("Rakesh Kumar" <rakeshkumar464@mail.com>)
Responses Re: Deadlock with one table - PostgreSQL is doing it right
List pgsql-general
Tree view
2017-12-21 12:41 GMT+01:00 Rakesh Kumar <rakeshkumar464@mail.com>:
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.

pgsql-general by date:

Previous
From: Hans Schou
Date:
Subject: Re: Deadlock with one table - PostgreSQL is doing it right
Next
From: "Rakesh Kumar"
Date:
Subject: Re: Deadlock with one table - PostgreSQL is doing it right