Nico Erichsen <[EMAIL PROTECTED]> writes:
> set transaction isolation level serializable;
> begin;
> update counters set counter1=(select counter1+1 from counters);
Try it the other way round:
begin;
set transaction isolation level serializable;
update c
Well, I'm a relative newbie to SQL, but I have been told that this behaviour
is a bug. I hope I didn't misunderstand something.
To reproduce, first create a table 'counters' that looks like that:
counter1
--
0
(1 row)
Then execute the following commands parallelly on two psq
