From: Denis P Gohel <sqllist@coralindia.com>
To: pgsql-sql@postgresql.org
Subject: Record Lock details
Date: Fri, 23 Apr 2004 14:13:57 +0530
Message-ID: <001201c4290f$1ecb3a60$3332a8c0@DENIS> (raw)
Hi all,
I am using PostgreSQL 7.3.1.
Is there a data dictionary in Postgres from where i can get the info about
locked rows of any table ? If possible the value of those locked record ?
My situation is like:
I have an ODBC application working on Postgres. There are Master child
tables. I want, if a user A is editing any document ( one master and set of
child records) in front-end application, the same should not be available to
other user for editing.
I thought of using SELECT FOR UPDATE. But, in my case, i need to display the
name of application user and other details about the locked row.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sqllist@coralindia.com
Subject: Re: Record Lock details
In-Reply-To: <001201c4290f$1ecb3a60$3332a8c0@DENIS>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox