Postgres Pro
Downloads
Home   >   mailing lists

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

From Kevin Grittner
Subject Re: Very long " in transaction" query
Date
Msg-id 4FA399E40200002500047870@gw.wicourts.gov
Whole thread Raw
In response to Re: Very long " in transaction" query  ("ktm@rice.edu" <ktm@rice.edu>)
Responses Re: Very long " in transaction" query
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Getting "ident" to work in Windows
Next
From: "ktm@rice.edu"
Date:
Subject: Re: Very long " in transaction" query