On 2014-06-19 1:46 AM, Josh Berkus wrote:
> Robert's right, not killing the "BEGIN;" only transactions is liable to
> result in user confusion unless we label those sessions differently in
> pg_stat_activity.
Wouldn't they be labeled differently already? i.e. the last query would
be "BEGIN". Unless your app tries to unsuccessfully use nested
transactions, you would know why it hasn't been killed.
.marko