Detecting locks

From: Sebastian Bossung <bossung(at)gmx(dot)de>
To: "Postgres General Mailinglist" <pgsql-general(at)postgresql(dot)org>
Subject: Detecting locks
Date: 2001-04-23 14:15:23
Message-ID: 01042316152300.01937@idefix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

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.

Sebastian

--
Sebastian Boßung - bossung(at)gmx(dot)de
http://www.bossung.org
# The idea is to die young as late as possible.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mike 2001-04-23 14:36:27 alter table questions
Previous Message Lark 2001-04-23 13:58:12 Can store binary data?