X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2D4CCD1B4B6 for ; Fri, 23 Apr 2004 05:48:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 24114-06 for ; Fri, 23 Apr 2004 05:48:35 -0300 (ADT) Received: from IPDAEZ0863MIA.hosting.innerhost.com (unknown [64.239.2.195]) by svr1.postgresql.org (Postfix) with ESMTP id CB85AD1D26C for ; Fri, 23 Apr 2004 05:48:32 -0300 (ADT) Received: from server2k ([61.11.69.170]) by IPDAEZ0863MIA.hosting.innerhost.com with MailEnable ESMTP; Fri, 23 Apr 2004 14:14:29 +0530 Received: from 192.168.50.51 by server2k ([192.168.50.102] running VPOP3) with SMTP for ; Fri, 23 Apr 2004 14:27:00 +0530 X-MSReally-From: sqllist@coralindia.com Message-ID: <001201c4290f$1ecb3a60$3332a8c0@DENIS> From: "Denis P Gohel" To: Subject: Record Lock details Date: Fri, 23 Apr 2004 14:13:57 +0530 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Server: VPOP3 V1.5.0 - Registered X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=4.5 tagged_above=0.0 required=5.0 tests=RCVD_IN_DSBL, RCVD_IN_SORBS, RCVD_IN_SORBS_HTTP, RCVD_IN_SORBS_MISC, RCVD_IN_SORBS_SOCKS X-Spam-Level: **** X-Archive-Number: 200404/251 X-Sequence-Number: 17626 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.