"Abraham, Danny" <danny_abraham@bmc.com> wrote:
> procpid | current_query
>
---------+---------------------------------------------------------------------
> 25936 | <IDLE> in transaction <== This is the locker
> - What exactly is the locker doing?
At the time you ran that, it wasn't doing anything in the database,
but it had not committed or rolled back the transaction it had
previously started.
> - Can I retrieve the Client PID somewhere (then by process name I
> will dive into the code).
If you're on Linux and this is a TCP connection, netstat should make
that easy. Are you?
-Kevin