Thread: locking mechanism

locking mechanism

From
"Sumaira Ali"
Date:
<div style="background-color:"><div>hi,</div><div> i wanted to know whether in postgresql, a single process can wait on
acquiringmultiple locks and if can hold</div><div>multiple locks at the same
time?</div><div>thanks</div><div>sumaira </div></div><brclear="all" /><hr />MSN 8 helps <a
href="http://g.msn.com/8HMBENUS/2743">ELIMINATEE-MAIL VIRUSES. </a> Get 2 months FREE*. 

Re: locking mechanism

From
Rod Taylor
Date:
On Sun, 2003-02-23 at 13:19, Sumaira Ali wrote:
> hi,
>  i wanted to know whether in postgresql, a single process can wait on
> acquiring multiple locks and if can hold
> multiple locks at the same time?

http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-lock.html

The docs answer those questions.  No to the first, yes to the second.

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc