Re: Timezones in 8.2.7

"Scott Marlowe" <scott.marlowe@gmail.com> writes:
> Weirdly, I'm getting the right offsets, but my timezone in pgsql is
> navajo...  For the OS it's America/Denver like I set it.  And there's
> no timezone set in postgresql.conf.

According to the TZ files, "Navajo" is just an alias for
"America/Denver":

Link    America/Denver        Navajo

IIRC we have the TZ-intuiting code set to prefer shorter names when it
has two equally good matches to the system's timezone behavior, so
that's why it's picking "Navajo".

            regards, tom lane