Re: [HACKERS] ERROR: WaitOnLock: error on wakeup - Aborting this transaction

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