David,
I may well be completely off track...

D> Suppose the update by client #1 is increasing the value of a numeric
D> field by 1 (e.g. 5 becomes 6). And the client #2's udpdate is of the
D> same operation. In other words, the two updates are non-conflicting.

do you mean something along the lines of

update sometable
set somevalue = somevalue + 1
where keyfield = :keyfield

?

Then, assuming the transactions are short-lived enough, I believe it
would be very rare to get an error in no_wait mode, and impossible in
wait mode.

What did I miss?

Ciao
--
Nando mailto:nandod@...