<html><div style='background-color:'><DIV>hi,</DIV>
<DIV> i found this piece of documentation on user locks in the postgresql source code in the file lock.c</DIV>
<DIV>"<FONT color=#008000 size=2>
<P>User locks are handled totally on the application side as</P>
<P>* long term cooperative locks which extend beyond the normal</P>
<P>* transaction boundaries. Their purpose is to indicate to an</P>
<P>* application that someone is `working' on an item. So it is</P>
<P>* possible to put an user lock on a tuple's oid, retrieve the</P>
<P>* tuple, work on it for an hour and then update it and remove</P>
<P>* the lock. While the lock is active other clients can still</P>
<P>* read and write the tuple but they can be aware that it has</P>
<P>* been <FONT size=5><EM><U>locked at the <STRONG>application </STRONG>level </U></EM></FONT>by someone."*/</P>
<P>could some one enlighten me on the meaning of " locked at application level in this context..!!</P>
<P>thanks</P>
<P>sumaira</P>
<P> </P>
<P> </P></FONT></DIV></div><br clear=all><hr>Tired of spam? Get <a href="http://g.msn.com/8HMAENUS/2734">advanced junk mail protection</a> with MSN 8.</html>