hi,
i found this piece of documentation on user locks in the postgresql source code in the file lock.c
"
User locks are handled totally on the application side as
* long term cooperative locks which extend beyond the normal
* transaction boundaries. Their purpose is to indicate to an
* application that someone is `working' on an item. So it is
* possible to put an user lock on a tuple's oid, retrieve the
* tuple, work on it for an hour and then update it and remove
* the lock. While the lock is active other clients can still
* read and write the tuple but they can be aware that it has
* been locked at the application level by someone."*/
could some one enlighten me on the meaning of " locked at application level in this context..!!
thanks
sumaira
Tired of spam? Get advanced junk mail protection with MSN 8.