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