| From: | "Denis P Gohel" <sqllist(at)coralindia(dot)com> | 
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> | 
| Subject: | Record Lock details | 
| Date: | 2004-04-23 08:43:57 | 
| Message-ID: | 001201c4290f$1ecb3a60$3332a8c0@DENIS | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-sql | 
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.
From which data dictionary, i should query.
Any help would be appreciated.
Thanx
Denis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-04-23 08:45:43 | Re: Server Side C programming Environment Set up | 
| Previous Message | ogjunk-pgjedan | 2004-04-23 07:53:50 | Re: Order by YYYY MM DD in reverse chrono order trouble |