Tom Lane дµÀ:
weiping he [EMAIL PROTECTED] writes:
txn1: txn2:
begin; begin;
update table_a set col= col + 1; update table_a set col = col + 1;
end; end;
if two transaction begin at exact the same time,
what's the result of 'col' after both transactions committed
in Read committed
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
You might want to check out yesterdays thread with the subject
Table Lock issue. Tom gave a really long and detailed explanation there
(which I'm very grateful for).
The problem you have looks similar, if not identical to the one in that
thread.
