win32 timezone map
Per discussion off-list with Tom, here is a patch to redo the way the
system timezone is detected on win32. Instead of trying to figure out
what to do, it just looks in a lookup table for all available timezones
(there is a finite and stable number of timezones on a win32 system,
unlike unixes that can have timezones added manually in most cases).
I've tried to match the timezones as good as I could using the city
names from the win32 descriptions and using some google. There are
probably some that can have better mappings - local knowledge is
probably the key there.
In passing the patch also removes some of the kludges put in the tz
detection code that were specific for win32.
//Magnus
"Magnus Hagander" <mha@sollentuna.net> writes:
Per discussion off-list with Tom, here is a patch to redo the way the
system timezone is detected on win32.
Er ... no patch attached?
regards, tom lane
Per discussion off-list with Tom, here is a patch to redo the way the
system timezone is detected on win32.Er ... no patch attached?
Heh. Oops.
//Magnus
Attachments:
tz_map.patchapplication/octet-stream; name=tz_map.patchDownload+142-40
Import Notes
Resolved by subject fallback
"Magnus Hagander" <mha@sollentuna.net> writes:
Per discussion off-list with Tom, here is a patch to redo the way the
system timezone is detected on win32.
Applied, along with some marginal hacking on the non-Windows case.
I extended the search back to 1904, which should serve to eliminate
those pesky Antarctica zones, and also added a tie-breaking rule for
identical zones: prefer shorter names, or alphabetically earlier names
when they are the same length. We'll see how people like that ...
regards, tom lane