Tom Lane schrieb:
"Michael Paesold" <[EMAIL PROTECTED]> writes:
The tests fail for PST/PDT in 2034.
This probably indicates that you've got TZ data reflecting the new US
DST rules. We have not updated the pre-8.0 regression test results
to deal with that.
You're right as far as I can tell. 8.1 has the expected output.
The failing tests are different instances of this basic example:
Expected:
Wed Mar 15 08:14:01 2000 PST + 34 years = Wed Mar 15 08:14:01 2034 PST
Here (and PostgreSQL >= 8.x):
Wed Mar 15 08:14:01 2000 PST + 34 years = Wed Mar 15 08:14:01 2034 PDT
Still, I don't understand why March 15th should be day light saving
time. But hey, I don't live in the PST8PDT time zone. ;-)
Thanks for your answer.
Best Regards,
Michael Paesold
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend