Обсуждение: detecting locks

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

detecting locks

От
jim@reptiles.org (Jim Mercer)
Дата:
i have a number of processes which deal with the same table.

i've run into locking contention.

is there a way for me to tell if there are connections waiting on a share
or exclusive lock?

i'm using libpq and C.

--
[ Jim Mercer    Reptilian Research      jim@reptiles.org   +1 416 410-5633 ]
[ The telephone, for those of you who  have forgotten, was a commonly used ]
[ communications technology in the days before electronic mail.            ]
[ They're still easy to find in most large cities. -- Nathaniel Borenstein ]