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

From: Hans Schou <hans(dot)schou(at)gmail(dot)com>
To: Rakesh Kumar <rakeshkumar464(at)mail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Deadlock with one table - PostgreSQL is doing it right
Date: 2017-12-21 20:38:54
Message-ID: CAApBw34wEybSW73nZoOCrTy1KJrEeZR9OnM2SY7AnFoHtKmqcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2017-12-21 12:41 GMT+01:00 Rakesh Kumar <rakeshkumar464(at)mail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Kumar 2017-12-21 20:50:17 Re: Deadlock with one table - PostgreSQL is doing it right
Previous Message Hans Schou 2017-12-21 20:35:04 Re: Deadlock with one table - PostgreSQL is doing it right