Hello
I was listening Your discusion. I have practical problem for which I write my
own locking system:
Personal rekords:
Name
zip
adress
Users A,B reads data from record:
John Smith
124312
Xstreet 27
Now A change zip and write all
B change adress and write
so zip is unchanged.
In pgsql I can solve it by SELECT FOR UPDATE but if user A goes for caffe
during his update
user B hangs for several minutes ...
Ther is no solution to check if record is in transaction ?
Am I right ?
Regards
Pawel Dubin