Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group