Re: REPOST: InitDB Failure on install

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: REPOST: InitDB Failure on install
Дата
Msg-id 145.1092605837@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: REPOST: InitDB Failure on install  ("Magnus Hagander" <mha@sollentuna.net>)
Список 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 по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Re: REPOST: InitDB Failure on install
Следующее
От: "rodrigo.miguel"
Дата:
Сообщение: Re: REPOST: InitDB Failure on install