From: george young <gry@ll.mit.edu>
To: pgsql-sql@postgresql.org
Subject: find open transactions/locks in 7.2?
Date: Mon, 9 Jun 2003 15:21:12 -0400
Message-ID: <20030609152112.0cf0e5e3.gry@ll.mit.edu> (raw)
[select version() --> PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 3.0.4]
I'm getting hangups every day or so, I presume due to some open transaction
that insert/update/delete'ed on a table that is used by my main app without
a commit.
Is there some way (in 7.2!) to find who's locking what or who has
a transaction open?
-- George
--
I cannot think why the whole bed of the ocean is
not one solid mass of oysters, so prolific they seem. Ah,
I am wandering! Strange how the brain controls the brain!
-- Sherlock Holmes in "The Dying Detective"
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gry@ll.mit.edu
Subject: Re: find open transactions/locks in 7.2?
In-Reply-To: <20030609152112.0cf0e5e3.gry@ll.mit.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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