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
in your application after which you send a query cancel. A waiting lock
still distinguishes it from a crashed program, ISTM.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
