Re: idle_in_transaction_timeout - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: idle_in_transaction_timeout
Date
Msg-id 53A226B4.6000102@joh.to
Whole thread Raw
In response to Re: idle_in_transaction_timeout  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: idle_in_transaction_timeout
Next
From: Josh Berkus
Date:
Subject: Re: idle_in_transaction_timeout