Received: from 12-234-58-129.client.attbi.com (12-234-58-129.client.attbi.com [12.234.58.129]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g05174m04459 for ; Fri, 4 Jan 2002 20:07:05 -0500 (EST) (envelope-from mislam@mindspring.com) Received: from jupiter (jupiter.sjc.mindspring.net [199.174.215.17]) by 12-234-58-129.client.attbi.com (8.11.2/8.8.7) with SMTP id g045BT310401 for ; Thu, 3 Jan 2002 21:11:29 -0800 Message-ID: <001301c19585$28c36e90$0100a8c0@sjc.mindspring.net> From: "Mir S Islam" To: Subject: who has lock on table/row Date: Fri, 4 Jan 2002 17:06:08 -0800 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 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200201/99 X-Sequence-Number: 6188 Is there a way to find out who(if any) has lock on a table ? Basically I am trying to do an insert update transaction and it is waiting and waitin until I hit cancel. Since the application heavily uses transactions/commits I am assuming somewhere it is leaving something open because of which the following queries are not updating. Thanks Mir