Understanding the output of make check

Started by miesiover 14 years ago2 messagesgeneral
Jump to latest
#1miesi
miesi@pc-h.de

Hi,

I've just compiled 9.1.1 in 32bit on Solaris snv_134 ("OpenSolaris
2010.11") with the Solaris Studio Compilers 12.2. The following Problem
is displayed

Maybe I'm blind, but where is the difference diff sees?

Thomas

*** /tmp/postgresql-9.1.1/src/test/regress/expected/timestamptz.out 
Thu Sep 22 23:57:57 2011
--- /tmp/postgresql-9.1.1/src/test/regress/results/timestamptz.out 
Sat Oct 22 14:34:41 2011
***************
*** 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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: miesi (#1)
Re: Understanding the output of make check

miesi <miesi@pc-h.de> writes:

Maybe I'm blind, but where is the difference diff sees?

PST vs PDT. Apparently you're using a system-provided timezone database
that lacks support for wider-than-32-bit time_t, so that dates beyond
2038 aren't handled correctly.

regards, tom lane