Sebastian Bossung writes:
> how do you find out if a row is locked _before_ using SELECT ... FOR UPADTE
> on it. The SELECT will wait for the lock to be removed (if there was one),
> making the user think the app crashed.
There is currently no way to detect locks. You could implement a timeout
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 MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
