Tatsuo Ishii wrote:
>
> I get above message from the backend while trying to update same raw
> from different transactions (I guess). Is this normal?
1=>begin;
2=>begin;
1=>update t set a = 1 where c = 1;
2=>update t set a = 1 where c = 2;
1=>update t set a = 2 where c = 2; -- blocked by 2
2=>update t set a = 2 where c = 1; --> deadlock
Or you didn't use BEGIN/END ?
Vadim