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
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 |