On Tue, Dec 13, 2011 at 1:53 PM, Helen Borrie <hele...@iinet.net.au> wrote: > > What the client can "see" depends on the isolation level of the transaction. > At all levels, your client's transaction sees its own changes. Those will > not be visible to any other transaction until your client's transaction > commits.
Helen is completely correct. The mechanism I described is the one used by Snapshot (concurrency) transactions. That's the mode that takes best advantage of MVCC for readers. Cheers, Ann