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

Re: system timezone regression failure

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: system timezone regression failure
Date: 2009-07-29 16:25:31
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers

Andrew Dunstan wrote:
> Tom Lane wrote:
>> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>>> 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.
>> Those regression tests were *intentionally* set up to fail if someone's
>> TZ support is not Y2038 clean.  This is not a bug.  Advise your client
>> to get some less-obsolete timezone data files; or don't depend on the
>> system TZ database.  (The only reason why you should do so is if it's
>> being kept up to date, eh?)
> Oh, you're right, I misread the diffs. The client is getting the 
> machines updated.

Well, this is interesting:

andrew(at)jimbo:~> rpm -q -i timezone
Name        : timezone                     Relocations: (not relocatable)
Version     : 2.4                               Vendor: SUSE LINUX 
Products GmbH, Nuernberg, Germany
Release     : 31.61                         Build Date: Thu 02 Apr 2009 
02:31:18 PM EDT
Install Date: Wed 29 Jul 2009 10:52:55 AM EDT      Build Host:
Group       : System/Base                   Source RPM: 
Size        : 712873                           License: BSD 3-Clause; 
GPL v2 or later; LGPL v2.1 or later
Signature   : DSA/SHA1, Fri 03 Apr 2009 09:20:05 AM EDT, Key ID 
Packager    :
URL         :
Summary     : Timezone descriptions
Description :
These are configuration files that describe available time zones. You
can select an appropriate time zone for your system with YaST.
Distribution: SUSE Linux Enterprise 10 (X86-64)

And I still get these errors. Looks like at least SUSE is not keeping 
up. I'll build without the system timezones.



In response to


pgsql-hackers by date

Next:From: Tom LaneDate: 2009-07-29 16:37:20
Subject: Re: system timezone regression failure
Previous:From: Euler Taveira de OliveiraDate: 2009-07-29 16:23:22
Subject: Re: WIP: to_char, support for EEEE format

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