agora inbox for pgsql-committers@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Sync our copy of the timezone library with IANA release tzcode20
Date: Fri, 26 Apr 2019 23:48:16 +0000
Message-ID: <E1hKAZk-0008DC-94@gemulon.postgresql.org> (raw)
Sync our copy of the timezone library with IANA release tzcode2019a.
This corrects a small bug in zic that caused it to output an incorrect
year-2440 transition in the Africa/Casablanca zone.
More interestingly, zic has grown a "-r" option that limits the range of
zone transitions that it will put into the output files. That might be
useful to people who don't like the weird GMT offsets that tzdb likes
to use for very old dates. It appears that for dates before the cutoff
time specified with -r, zic will use the zone's standard-time offset
as of the cutoff time. So for example one might do
make install ZIC_OPTIONS='-r @-1893456000'
to cause all dates before 1910-01-01 to be treated as though 1910
standard time prevailed indefinitely far back. (Don't blame me for
the unfriendly way of specifying the cutoff time --- it's seconds
since or before the Unix epoch. You can use extract(epoch ...)
to calculate it.)
As usual, back-patch to all supported branches.
Branch
------
REL9_6_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/28aa0ee4fd780ffa1cbe4164900a087690506ba9
Modified Files
--------------
src/timezone/Makefile | 5 +-
src/timezone/README | 4 +-
src/timezone/private.h | 8 ++
src/timezone/tzfile.h | 3 +
src/timezone/zic.c | 300 ++++++++++++++++++++++++++++++++++++-------------
5 files changed, 237 insertions(+), 83 deletions(-)
view thread (104+ messages) latest in thread
Message-ID: <E1hKAZk-0008DC-94@gemulon.postgresql.org>
Permalink: ../E1hKAZk-0008DC-94@gemulon.postgresql.org/
Also on: postgresql.org/message-id/E1hKAZk-0008DC-94@gemulon.postgresql.org
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Sync our copy of the timezone library with IANA release tzcode20
In-Reply-To: <E1hKAZk-0008DC-94@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox