Re: [PATCH] initdb: map Windows' new Canadian time zone names

I wrote:
> Thanks! I'll check this and put together a finished patch.

So after a few minutes trying to compare information presented in
several different formats, I got frustrated enough to decide that some
automation is in order. If we are taking CLDR's data as gospel from
here on out, let's just make a script to generate what findtimezone.c
needs from CLDR's windowsZones.xml. A little while later I had the
attached patch series. This doesn't represent total automation, as
it expects you to run the new Perl script by hand, and you're still
responsible for moving obsoleted entries somewhere else by hand.
But given that we shouldn't need to run this very often, I figured
that addressing those things would be well past the point of
diminishing returns.

The new data that I generated this way agrees with CyberNative's
conclusions, except that there are some differences in the comment
lines, which is perhaps unsurprising since those are human-generated.
I also notice that the win32tzlist.out file that David sent has
differences that seem to amount to comment-line differences, but
I'm not really sure where that data is coming from on the Windows
side.

regards, tom lane