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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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-*/

Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online.

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-2017 The PostgreSQL Global Development Group