Re: Time Zone Error - Mailing list pgsql-general

From Tom Lane
Subject Re: Time Zone Error
Date
Msg-id 22966.1179408483@sss.pgh.pa.us
Whole thread Raw
In response to Re: Time Zone Error  (Richard Huxton <dev@archonet.com>)
Responses Re: Time Zone Error
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Hang on - did the US not alter the daylight-saving date recently? I'll
> bet that's the issue.

We're well past both the old and new change dates though, so for any
combination of OS and Postgres knowing/not knowing about the law change,
they ought to be back in sync by now.

[ thinks... ]  It seems entirely plausible that Windows 2003 doesn't
know about the law change, especially if it's not been updated lately.
Maybe the OP turned off the automatic DST switchover at the OS level
upon realizing it was wrong?  I don't think PG's code for translating
the Windows setting into a PG setting is able to detect that DST
switchover has been disabled.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Time Zone Error
Next
From: Lee Keel
Date:
Subject: Large Database Restore