Re: Patch for PKST timezone - Mailing list pgsql-hackers

From Joachim Wieland
Subject Re: Patch for PKST timezone
Date
Msg-id AANLkTil295rrv861mjtHTP5qRvsWL9ki5fjeAxh1cL_S@mail.gmail.com
Whole thread Raw
In response to Re: Patch for PKST timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Wed, May 12, 2010 at 12:39 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Joachim Wieland <joe@mcknight.de> writes:
>> Good we have found that inconsistency now, so let's add PKST.
>
> OK, done.  BTW, I notice that PKT was labeled "(not in zic)", which
> is not the case, per this discussion.  I seem to recall having noticed
> some others that seemed to be mislabeled the same way.  What process did
> you use to compare this list to the zic files, and do we need to revisit
> it?

I have used a modified version of zic.c that outputs the data while
generating the binary timezone files. Generating the timezone offset
files from that then included some scripts and some manual work. It
seems that we should have an automated process for that, at least for
checking against our current set. I'll see if I can come up with that.
PKST for example was valid only for a single year in the past but in
the newer timezone data it is now valid forever. Ideally we can run a
script that tells us about such changes whenever we bring in new
timezone data.


Joachim


pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Performance problem in textanycat/anytextcat
Next
From: Bruce Momjian
Date:
Subject: Re: pg_upgrade and extra_float_digits