Re: Very long " in transaction" query - Mailing list pgsql-admin

From ktm@rice.edu
Subject Re: Very long " in transaction" query
Date
Msg-id 20120504150553.GL32303@aart.rice.edu
Whole thread Raw
In response to Re: Very long " in transaction" query  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
On Fri, May 04, 2012 at 08:57:08AM -0500, Kevin Grittner wrote:
> "ktm@rice.edu" <ktm@rice.edu> wrote:
>
> > You may also want to consider setting a statement_timeout to
> > prevent this until you can find the problem with the application.
>
> How would a statement timeout help close a transaction on an idle
> connection?  It's idle because no statements are being run.
>
> -Kevin

Yes, you are correct. I misunderstood. Too bad we do not have a
transaction_timeout.

Regards,
Ken

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Very long " in transaction" query
Next
From: Craig James
Date:
Subject: C/C++ Linker Problem in Postgres extension functions