Deadlock with one table - PostgreSQL is doing it right - Mailing list pgsql-general

From Hans Schou
Subject Deadlock with one table - PostgreSQL is doing it right
Date
Msg-id CAApBw36hmDPXTN44Fxx=CCgTgf+-iDsBzNOTtnF-QaCfAOSncQ@mail.gmail.com
Whole thread Raw
Responses Re: Deadlock with one table - PostgreSQL is doing it right
Re: Deadlock with one table - PostgreSQL is doing it right
List pgsql-general
Hi

FYI - if it has any interest

During my preparation for describing what happens when two processes update the same row in a table, I came across that PostgreSQL is doing right and Oracle is doing it wrong.

The situation is a process which get a deadlock, but because it is a script, it sends a commit anyway. This is bad behavior by humans but that's how they are.

After both processes commit's the table should be:
 i |  n
---+---
 1 | 11
 2 | 21
in Oracle it is:
 i |  n
---+---
 1 | 11
 2 | 22

PostgreSQL: https://youtu.be/rH-inFRMcvQ
Oracle: https://youtu.be/l2IGoaWql64

PostgreSQL:
A
select * from t;
begin;
update t set n=n+1 where i=2;

B
begin;
update t set n=n+1 where i=1;
update t set n=n+1 where i=2;

A
update t set n=n+1 where i=1;

B
commit;

A
commit;

best regards
hans

pgsql-general by date:

Previous
From: Olivier Macchioni
Date:
Subject: Dynamic Enum?
Next
From: Dave Cramer
Date:
Subject: Re: psycopg2 and java gssapi questions