Re: [pgsql-hackers-win32] Weird new time zone

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] Weird new time zone
Date: 2004-07-22 10:11:29
Message-ID: 40FF92D1.9040508@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> But in any case, I've committed code that implements Oliver's idea.
> Could folks take another swipe at it and see if it works well in their
> local zones? Also, it'd still be interesting to see if we could #ifdef
> out the matching on zone names for Windows and still get reasonable
> results.

Sadly, it now thinks I live a bit further south than I actually do :)

template1=# show timezone;
TimeZone
--------------------
Antarctica/McMurdo
(1 row)

The only timezones that get positive scores during startup are:

DEBUG: TZ "Antarctica/McMurdo" gets max score 2080
DEBUG: TZ "Antarctica/South_Pole" gets max score 2080
DEBUG: TZ "Pacific/Auckland" gets max score 2080
DEBUG: TZ "NZ" gets max score 2080

Either of "NZ" or "Pacific/Auckland" would be correct.

From memory it picked Pacific/Auckland with the slightly older code.

-O

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Oliver Jowett 2004-07-22 10:58:27 Re: [pgsql-hackers-win32] Weird new time zone
Previous Message Christopher Kings-Lynne 2004-07-22 07:54:46 Re: Fixing PKs and Uniques in tablespaces