Re: Timezone fun (bugs and a request) - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Timezone fun (bugs and a request)
Date
Msg-id 200405251357.i4PDvko14127@candle.pha.pa.us
Whole thread Raw
In response to Re: Timezone fun (bugs and a request)  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-hackers
Oliver Jowett wrote:
> Tom Lane wrote:
> > Oliver Jowett <oliver@opencloud.com> writes:
> > 
> >>Also, unless I'm missing something, shouldn't Chile (Alvaro's timezone?) 
> >>be behind GMT (GMT-something) not ahead of it (GMT+something)?
> > 
> > 
> > Part of the confusion here is that the zone names in the zic database
> > follow POSIX rules: plus is west of Greenwich.  AFAICS it's doing the
> > right thing in selecting Etc/GMT-12 for you.
> 
> Ew! That's disgusting! What possessed POSIX to do this the opposite way 
> to pretty much everything else?

You want ugly, look at how we find the system timezone --- we scan
forward for 14 months looking at the timezone abbreviations returned by
the operating system.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_ctl.c
Next
From: Tom Lane
Date:
Subject: Re: Timezone fun (bugs and a request)