Skip site navigation (1) Skip section navigation (2)

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

From: Dexter Tad-y <dexterbt1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: is_locked() function for select-for-update locked rows
Date: 2004-02-16 13:39:36
Message-ID: 20040216133936.57499.qmail@web42001.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

pgsql-novice by date

Next:From: userDate: 2004-02-16 15:29:53
Subject: Re: Createdb fails
Previous:From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]Date: 2004-02-16 12:50:06
Subject: PostgreSQL From xinit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group