From: Peter Eisentraut <peter_e@gmx.net>
To: Denis P Gohel <sqllist@coralindia.com>
To: pgsql-sql@postgresql.org
Subject: Re: Record Lock details
Date: Fri, 23 Apr 2004 12:03:01 +0200
Message-ID: <200404231203.01835.peter_e@gmx.net> (raw)
In-Reply-To: <001201c4290f$1ecb3a60$3332a8c0@DENIS>
References: <001201c4290f$1ecb3a60$3332a8c0@DENIS>
Am Freitag, 23. April 2004 10:43 schrieb Denis P Gohel:
> 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 ?
No, this information is not available for end users.
> 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.
Keeping in mind that long-running transactions are not a good idea anyway, you
should probably consider a user-space cooperative locking model. There is
something in contrib/userlock, but I'm not sure whether that fits what you
need.
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: peter_e@gmx.net, sqllist@coralindia.com
Subject: Re: Record Lock details
In-Reply-To: <200404231203.01835.peter_e@gmx.net>
* 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