I am executing the following queries (id has a unique key): 1) begin; 1) delete from forum where id = 20; 1) insert into forum (id, name) values (20, 'test'); 2) delete from forum where id = 20; 1) commit;Queries marked with 1) are executed by process 1 and queries marked with 2) are executed by process 2.
The problem is that process 2 gets the message 'DELETE 0'. I would expect him to get the message 'DELETE 1'.
Can anyone explain this behaviour? Thanks in advance! Matthijs Melissen
