Обсуждение: is_locked() function for select-for-update locked rows

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

is_locked() function for select-for-update locked rows

От
Dexter Tad-y
Дата:
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