Re: Log full of: statement_timeout out of the valid range.

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Log full of: statement_timeout out of the valid range.
Date: 2010-01-25 17:23:17
Message-ID: 20100125172317.GA9499@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Abraham, Danny <danny_abraham(at)bmc(dot)com> wrote:

> ctrlm700=> show statement_timeout;
>
> statement_timeout
>
> -------------------
>
> 1h

I'm not sure if this is a valid value, the documentation says:

statement_timeout (integer)
Abort any statement that takes over the specified number of
milliseconds

If you really want 1 hour try to change that to 3600000. But maybe i'm
wrong and you should read the other answer from Joshua Drake.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2010-01-25 18:24:27 Re: Old/New
Previous Message Abraham, Danny 2010-01-25 16:51:53 Re: Log full of: statement_timeout out of the valid range.