Re: Anyone want to update our Windows timezone map?

From: Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Anyone want to update our Windows timezone map?
Date: 2016-08-15 20:35:34
Message-ID: CAEepm=3gpB5Mv+EfY8cAfTaGJDmGEfJq6PCzCaocXRZZ5nGdxg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Aug 16, 2016 at 7:19 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> src/timezone/README saith
>
> When there has been a new release of Windows (probably including Service
> Packs), the list of matching timezones need to be updated. Run the
> script in src/tools/win32tzlist.pl on a Windows machine running this new
> release and apply any new timezones that it detects. Never remove any
> mappings in case they are removed in Windows, since we still need to
> match properly on the old version.
>
> We have certainly not been doing that on a regular basis (as best I can
> tell, no such changes have been made since 2010). Does anybody who uses
> Windows want to deal with it? Or at least do it once so that our Windows
> TZ info is less than 5 years out of date?

By the way, I noticed that Unicode CLDR publishes this data set which
seems to be the same sort of thing:

http://www.unicode.org/cldr/charts/29/supplemental/zone_tzid.html

Could that be a better source than dumping stuff from arbitrary
Windows versions?

--
Thomas Munro
http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2016-08-15 20:36:06 Re: Let's get rid of the separate minor version numbers for shlibs
Previous Message Stephen Frost 2016-08-15 19:42:18 Re: PATCH: Exclude additional directories in pg_basebackup