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
transaction.
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;
HTH,
Tino.
--
www.spiritualdesign-chemnitz.de
www.lebensraum11.de
Tino Schwarze * Parkstraße 17h * 09120 Chemnitz
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
