Re: REPOST: InitDB Failure on install - Mailing list pgsql-hackers-win32

From Tom Lane
Subject Re: REPOST: InitDB Failure on install
Date
Msg-id 145.1092605837@sss.pgh.pa.us
Whole thread Raw
In response to Re: REPOST: InitDB Failure on install  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-hackers-win32
"Magnus Hagander" <mha@sollentuna.net> writes:
> Hmm. There is GetTimeZoneInformation(). It returns a name, but my guess
> is strftime just uses that one so it'll return the same thing.

Probably.  I did a little googling and was slightly stunned to realize
just how little Windows knows about time zones:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sysinfo/base/time_zone_information_str.asp
The above struct is what is passed in by SetTimeZoneInformation, so
evidently there just isn't any semantics beyond that.  Ick.  No wonder
we were getting nowhere with the match-the-behavior approach --- the
system simply hasn't got the capability to deal with the concept that
DST rules have changed over time.

So I'd speculate that indeed there is only one version of the standard
zone name and only one version of the daylight zone name, and in a
localized Windows system it's gonna be the localized name :-(

Could we do anything with looking for a match to the Bias, StandardDate,
and DaylightDate members of TIME_ZONE_INFORMATION, and not examining the
name members at all?  I do not know if that will give us unique matches
or not, but it seems like the only approach that won't result in a
vastly bloated lookup table.

            regards, tom lane

pgsql-hackers-win32 by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: REPOST: InitDB Failure on install
Next
From: "rodrigo.miguel"
Date:
Subject: Re: REPOST: InitDB Failure on install