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?
thanks
sumaira MSN 8 helps ELIMINATE E-MAIL VIRUSES.  Get 2 months FREE*.

Sun, 23 Feb 2003 10:19:51 -0800
"Sumaira Ali" <nat_lazy@hotmail.com>
locking mechanism
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
23 Feb 2003 13:46:16 -0500
Rod Taylor <rbt@rbt.ca>
Re: locking mechanism