WHo is locking me? - Mailing list pgsql-admin

Hi,

A process hangs forever.
When using this query...

SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
       pg_stat_get_backend_activity(s.backendid) AS current_query
    FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
and  pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';


I get...


 procpid |                            current_query
---------+---------------------------------------------------------------------
   26702 | SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
         :        pg_stat_get_backend_activity(s.backendid) AS current_query
         :     FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
         : where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
         : and  pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';
   21282 | update cmr_lastno set lastisn=lastisn+1 where tablename='DANNY';
   25936 | <IDLE> in transaction  <== This is the locker

And the question:
- What exactly is the locker doing?
- Can I retrieve the Client PID somewhere (then by process name I will dive into the code).

Thanks a lot

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com