I am having a problem with having idle sessions in transactions. In pgAdmin
Server Status, it is showing "RELEASE_EXEC_SVP_XXXXXX" (XXXXXX data are varied)
as its query and it's locks also contain a lot of these
"RELEASE_EXEC_SVP_XXXXXX" entries. What do these mean? These commonly cause
lock blocking problems because these sessions sometimes lock other rows but the
session status is always "Idle in transaction". I do not know why there are
sessions like these. I have reviewed our system and do not see any possibility
of transactions getting started that are not rollbacked or committed and just
stay idle so this must be something internal to postgresql.
Version of PostgreSQL is 9.2.8 running on Windows using psqlodbc driver
9.0.3.210.
