"Matthijs Melissen" <melissen@xxxxxxxxxx> writes: > 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; > The problem is that process 2 gets the message 'DELETE 0'. I would expect > him to get the message 'DELETE 1'. Why do you find that strange? Process 1 hasn't committed its insert yet. regards, tom lane
