system timezone regression failure

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: system timezone regression failure
Date: 2009-07-28 19:02:06
Message-ID: 4A6F4B2E.7030000@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Building 8.4 on a client's system, I get a regression failure apparently
due to some difference between the system's timezone DB and what out
regression tests expect, as shown below.

I'm wondering if we should not disable the timestamptz regression test
when we configure with the system timezone db. I guess i could patch the
SRPM by providing an alternative result file - not sure if it's worth it
though.

cheers

andrew

***
/usr/local/src/rpms/BUILD/postgresql-8.4.0/src/test/regress/expected/timestamptz.out
2009-03-21 21:12:32.000000000 -0400
---
/usr/local/src/rpms/BUILD/postgresql-8.4.0/src/test/regress/results/timestamptz.out
2009-07-28 12:33:15.000000000 -0400
***************
*** 153,159 ****
SELECT '20500710 173201 Europe/Helsinki'::timestamptz; -- DST
timestamptz
------------------------------
! Sun Jul 10 07:32:01 2050 PDT
(1 row)

SELECT '20500110 173201 Europe/Helsinki'::timestamptz; -- non-DST
--- 153,159 ----
SELECT '20500710 173201 Europe/Helsinki'::timestamptz; -- DST
timestamptz
------------------------------
! Sun Jul 10 07:32:01 2050 PST
(1 row)

SELECT '20500110 173201 Europe/Helsinki'::timestamptz; -- non-DST
***************
*** 165,171 ****
SELECT '205000-07-10 17:32:01 Europe/Helsinki'::timestamptz; -- DST
timestamptz
--------------------------------
! Thu Jul 10 07:32:01 205000 PDT
(1 row)

SELECT '205000-01-10 17:32:01 Europe/Helsinki'::timestamptz; -- non-DST
--- 165,171 ----
SELECT '205000-07-10 17:32:01 Europe/Helsinki'::timestamptz; -- DST
timestamptz
--------------------------------
! Thu Jul 10 07:32:01 205000 PST
(1 row)

SELECT '205000-01-10 17:32:01 Europe/Helsinki'::timestamptz; -- non-DST

======================================================================

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2009-07-28 19:02:17 Re: fix: plpgsql: return query and dropped columns problem
Previous Message Tom Lane 2009-07-28 17:41:47 Re: WIP: Deferrable unique constraints