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

Поиск

Список

Период

Сортировка

От	Hans Schou
Тема	Re: Deadlock with one table - PostgreSQL is doing it right
Дата	22 декабря 2017 г. 02:38:54
Msg-id	CAApBw34wEybSW73nZoOCrTy1KJrEeZR9OnM2SY7AnFoHtKmqcw@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Deadlock with one table - PostgreSQL is doing it right ("Rakesh Kumar" <rakeshkumar464@mail.com>)
Ответы	Re: Deadlock with one table - PostgreSQL is doing it right ("Rakesh Kumar" <rakeshkumar464@mail.com>)
Список	pgsql-general

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 по дате отправления:

От: Hans Schou
Дата: 22 декабря 2017 г., 02:35:04
Сообщение: Re: Deadlock with one table - PostgreSQL is doing it right

От: "Rakesh Kumar"
Дата: 22 декабря 2017 г., 02:50:17
Сообщение: Re: Deadlock with one table - PostgreSQL is doing it right