pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
who has lock on table/row 2+ messages / 2 participants [nested] [flat]
* who has lock on table/row @ 2002-01-05 01:06 Mir S Islam <mislam@mindspring.com> 0 siblings, 1 reply; 2+ messages in thread From: Mir S Islam @ 2002-01-05 01:06 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: who has lock on table/row @ 2002-01-11 22:01 Tom Lane <tgl@sss.pgh.pa.us> parent: Mir S Islam <mislam@mindspring.com> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2002-01-11 22:01 UTC (permalink / raw) To: Mir S Islam <mislam@mindspring.com>; +Cc: pgsql-sql "Mir S Islam" <mislam@mindspring.com> writes: > Is there a way to find out who(if any) has lock on a table ? Not at the moment. We need a utility to dump out the contents of the lock manager's data structures, but no one's got round to it. > 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. Try using "ps" to look for a backend that is sitting in "idle in transaction" state. regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2002-01-11 22:01 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2002-01-05 01:06 who has lock on table/row Mir S Islam <mislam@mindspring.com> 2002-01-11 22:01 ` Tom Lane <tgl@sss.pgh.pa.us>
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