| 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: | Whole Thread | Raw Message | 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°
| 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. |