Re: [HACKERS] locking mechanism

2003-07-23 Thread Tom Lane
"Jenny -" <[EMAIL PROTECTED]> writes: > 1)If the same PROCLOCK has some already-granted locks and > be waiting for more, how do we know? You look at the PROC object to see whether it is waiting, and if so for what. regards, tom lane ---(end of

Re: [HACKERS] locking mechanism

2003-02-23 Thread Rod Taylor
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