"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
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