Re: idle in transaction, why

On 11/06/2017 01:09 PM, David G. Johnston wrote:
> On Mon, Nov 6, 2017 at 12:32 PM, Rob Sargent <robjsargent(at)gmail(dot)com
> <mailto:robjsargent(at)gmail(dot)com>>wrote:
>
> Using postgres 10-beta3 (hopefully 10.0 this week) on virtual
> CentOS7 and this JDBC driver postgresql:42.1.4
>
>
> The postgresql.conf file has
>
> #idle_in_transaction_session_timeout = 0 # in
> milliseconds, 0 is disabled
>
>
> ​There are numerous places where default settings can be configured.
>
> https://www.postgresql.org/docs/10/static/config-setting.html
>
> You should probably login as your application user and do "show
> idle_in_transaction_session_timeout" to see what a clean session has
> for a value and then figure out from there where that value is coming
> from.
>
> David J.
>
From logging in with the application role I get

coon=> show idle_in_transaction_session_timeout;
idle_in_transaction_session_timeout
-------------------------------------
0
(1 row)