Beta2 "horology" test failure on non-US zoneinfo/posixrules

From: Radoslaw Zielinski <radek(at)pld-linux(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Beta2 "horology" test failure on non-US zoneinfo/posixrules
Date: 2007-11-11 13:45:39
Message-ID: 20071111134539.GA3460@bzium
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

I'm building beta2 --with-system-tzdata, my /usr/share/zoneinfo/posixrules
is a symbolic link to localtime, which is Europe/London; the horology test
fails in three places:

--- expected/horology.out 2007-07-25 18:22:36.000000000 +0100
+++ results/horology.out 2007-11-10 21:15:50.325553844 +0000
@@ -605,7 +605,7 @@
SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00";
Apr 3, 12:00
------------------------------
- Sun Apr 03 12:00:00 2005 CDT
+ Sun Apr 03 13:00:00 2005 CDT
(1 row)

SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
@@ -617,13 +617,13 @@
SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
Apr 2, 12:00
------------------------------
- Sat Apr 02 12:00:00 2005 CST
+ Sat Apr 02 12:00:00 2005 CDT
(1 row)

SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
Apr 2, 11:00
------------------------------
- Sat Apr 02 11:00:00 2005 CST
+ Sat Apr 02 12:00:00 2005 CDT
(1 row)

RESET TIME ZONE;

If .../posixrules is a symlink to America/New_York (as originally in
tzdata) or does not exist at all, the test passes. Question: what is
broken here? Postgres, my setup, the concept behind posixrules...?

--
Radosław Zieliński <radek(at)pld-linux(dot)org>

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-11-11 14:52:57 Re: High Availability, Load Balancing, and Replication Feature Matrix
Previous Message Markus Schiltknecht 2007-11-11 13:11:50 Re: High Availability, Load Balancing, and Replication Feature Matrix