# # an ugly hack to disable some "horology" tests,which fail if built # --with-system-tzdata and non-US /usr/share/zoneinfo/posixrules: # http://www.nabble.com/Beta2-%22horology%22-test-failure-on-non-US-zoneinfo-posixrules-td13691442.html # --- postgresql-8.3RC1/src/test/regress/expected/horology.out 2007-07-25 18:22:36.000000000 +0100 +++ postgresql-8.3.0/src/test/regress/expected/horology.out 2008-02-04 20:20:16.091518646 +0000 @@ -602,30 +602,12 @@ -- timestamp with time zone, interval arithmetic around DST change SET TIME ZONE 'CST7CDT'; -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 -(1 row) - SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; Apr 3, 13:00 ------------------------------ Sun Apr 03 13:00:00 2005 CDT (1 row) -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 -(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 -(1 row) - RESET TIME ZONE; SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am"; Jan_01_1994_10am --- postgresql-8.3RC1/src/test/regress/sql/horology.sql 2007-07-25 18:22:37.000000000 +0100 +++ postgresql-8.3.0/src/test/regress/sql/horology.sql 2008-02-04 20:20:18.091381199 +0000 @@ -114,10 +114,7 @@ -- timestamp with time zone, interval arithmetic around DST change SET TIME ZONE 'CST7CDT'; -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00"; SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00"; -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00"; RESET TIME ZONE;