who has lock on table/row - Mailing list pgsql-sql

From Mir S Islam
Subject who has lock on table/row
Date
Msg-id 001301c19585$28c36e90$0100a8c0@sjc.mindspring.net
Whole thread Raw
Responses Re: who has lock on table/row  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
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



pgsql-sql by date:

Previous
From: Björn Lundin
Date:
Subject: Re: SQL syntax help needed
Next
From: "Karl Raven"
Date:
Subject: Re: change null to 0 in SQL script