is_locked() function for select-for-update locked rows -
02-16-2004
, 07:39 AM
Greetings,
I am interested in writing a stored procedure
(PL/Perl) in determining whether a particular row is
currently locked (using SELECT ..FOR UPDATE) by
another transaction. Any suggestions where can I
start? I'm going to use this primarily to avoid
blocking using selecting for update. Thanks.
Dexter Tad-y
dexterbt1 /*-at-*/ yahoo.com
__________________________________
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.
http://taxes.yahoo.com/filing.html
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org) |