List all querys from a open transaction - Mailing list pgsql-admin

Hey all,

anyone know how can I show all querys from a open transaction?

pg_stat_activity only show "<IDLE> in transaction", any ideas?

Sample:

### conection 1
root@server:~# psql -U postgres
psql (8.4.4)

postgres=# begin;
BEGIN
postgres=# select now();
              now
-------------------------------
 2011-07-05 20:25:39.535244-03
(1 row)

### connection 2
root@server:~# psql -U postgres
psql (8.4.4)

postgres=# select current_query from pg_stat_activity where
current_query <> '<IDLE>' and current_query not like
'%pg_stat_activty%';
     current_query
-----------------------
 <IDLE> in transaction
(1 row)


--
Atenciosamente,
Sebastian Selau Webber Colombo