| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | Jamie Deppeler <jamie(at)doitonce(dot)net(dot)au>, General PostgreSQL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Time Zone Error |
| Date: | 2007-05-17 13:28:03 |
| Message-ID: | 22966.1179408483@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Richard Huxton <dev(at)archonet(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-05-17 13:37:43 | Re: Granting privileges on views to group roles |
| Previous Message | Tom Lane | 2007-05-17 13:19:30 | Re: Time Zone Error |