On Tue, Sep 11, 2007 at 12:26:18PM +0000, Mateus Interciso wrote:
> Thanks for your reply.
> Is there any way on PostgreSQL that I can see the transaction that
> haven't been commited?
The following queries shows open transactions and locks held by the
select c.relname,l.transaction,l.pid,l.granted,l.mode from pg_class
c,pg_locks l where l.relation = c.oid order by l.pid, l.mode;
Tino Schwarze * Parkstraße 17h * 09120 Chemnitz
In response to
pgsql-admin by date
|Next:||From: Brian Staszewski||Date: 2007-09-11 16:31:46|
|Subject: Re: Close open transactions soon to avoid wraparound problems|
|Previous:||From: Mateus Interciso||Date: 2007-09-11 13:43:59|
|Subject: Re: Idle transactions|