John,

>(That's kind of interesting. Because if trans 1 commits then you
>*can* insert 1,5. What you can and cant do changes inside a snapshot
>trans, which seems a bit of a Isolation violation to me.

I think it works. In snapshot mode (wait) this is what I saw.

Create a primary key index on test.f1
insert into test (f1) values (1);
commit;
update test set f1 = 5;

then in another connection

insert into test (f1) values (1);

That insert waits until the first transaction
either commits or rolls back. If it commits,
the second connection proceeds. If the first
transaction rolls back, the second gets an
error.

Regards,


Ann