Re: Mismapping of Mountain Time - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Mismapping of Mountain Time
Date
Msg-id 10125.1299194677@sss.pgh.pa.us
Whole thread Raw
In response to Re: Mismapping of Mountain Time  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> It's not all that separate: per the Olsen database,
>>
>> Link    America/Denver        US/Mountain
>> Link    America/Denver        Navajo

> Yeah, it gets complicated, since the State of Arizona ignores
> Daylight Saving Time adjustments.  On the other hand, most of
> Arizona is covered by the Navajo Nation, which *does* observe DST.
> Except for some government offices on the reservation.  And the Hopi
> Nation goes along with the local state rules, so pay attention.  :-/

> So, yeah, Navajo is always the same as most of US/Mountain, but the
> parts in Arizona don't ignore DST like the rest of the state does.

Well, the Arizona rules are described by the America/Phoenix zone,
which we *can* tell apart from America/Denver because there's an
actual behavioral difference.  If the user wanted Arizona rules
and selected US/Mountain, that's their mistake not ours.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Mismapping of Mountain Time
Next
From: Tom Lane
Date:
Subject: Re: Mismapping of Mountain Time