elein <[EMAIL PROTECTED]> writes:
> Running 8.3RC1
> I have an sql script where one or more create index statements
> raise a statement timeout message. The statement timeout is
> set to 1d.
Hmmm ... are you using integer timestamps by any chance?
It looks to me like TimestampTzPlusMilliseconds() would overflow
for such a large timeout.
> The script runs in ~3 hours including the timeout messages.
If I'm doing the math correctly, 1 day would overflow to about
8 minutes in microseconds, so if you're seeing individual statements
time out after more than that then there's something else going on.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
