[GENERAL] Lock rekord

[Paweł Dubin]

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