konst583(at)mail(dot)ru writes:> Select of 2-nd transaction will return new value from a and old value from> b
That's what FOR UPDATE is designed to do. If you don't like it, useserializable mode.
regards, tom lane