I want two users to execute the following queries:
1) delete from forum where id = 'A';
1) insert into forum (id, name) values ('A', 'testa');
2) delete from forum where id = 'A';
2) insert into forum (id, name) values ('A', 'testb');
id is a unique key. The numbers designate the user (1 and 2)
e 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)-
Alban Hertroys wrote:
Pavan Deolasee wrote:
On 3/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Matthijs Melissen" <[EMAIL PROTECTED]> 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
