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



---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to