Обсуждение: locking mechanism

Поиск
Список
Период
Сортировка

locking mechanism

От
"Sumaira Ali"
Дата:
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*.

Re: locking mechanism

От
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 those questions.  No to the first, yes to the second.

--
Rod Taylor <rbt@rbt.ca>

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