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

Поиск
Список
Период
Сортировка
От Hans Schou
Тема Re: Deadlock with one table - PostgreSQL is doing it right
Дата
Msg-id CAApBw36dW+aD-wm96Z5A5p=Nx3sNHknaJ40E-LMWmtToBJW10A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Deadlock with one table - PostgreSQL is doing it right  ("Rakesh Kumar" <rakeshkumar464@mail.com>)
Список pgsql-general
Дерево обсуждения
2017-12-21 21:50 GMT+01:00 Rakesh Kumar <rakeshkumar464@mail.com>:
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


В списке pgsql-general по дате отправления:

Предыдущее
От: Ken Tanzer
Дата:
Сообщение: Re: Intersection or zero-column queries
Следующее
От: Ertan Küçükoğlu
Дата:
Сообщение: Character with byte sequence error