Timezones on localized windows

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Timezones on localized windows
Date: 2004-08-31 19:36:45
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE475B7D@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

This patch attempts to fix the issue with localized timezones on
Windows.

Recap: When running on a localized windows version, the timezone name
returned is also localized, and therefor does not match our lookup
table.

Solution: The registry contains both the name of the timezone in english
and the localized name. The patch adds code to scan the registry for the
localized name and gets the english name from that, and then rescans the
table.

I have tested this on a Swedish WinXP, and it works without problems.
The registry layout is the same in Win2k, but I haven't specifically
tested it. It's also the same on different languages but again only
Swedish is tested.

//Magnus

Attachment Content-Type Size
win32localtz.patch application/octet-stream 3.6 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Greg Sabino Mullane 2004-08-31 23:14:56 Typo in tab-complete.c
Previous Message Bruce Momjian 2004-08-31 18:57:28 Re: [PATCHES] ALTER SCHEMA ... SET TABLESPACE