List all querys from a open transaction

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(at)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(at)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