Mismapping of Mountain Time

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Mismapping of Mountain Time
Date: 2011-03-03 22:31:06
Message-ID: 4D7016AA.2090609@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


uname -a
Linux hemingway 2.6.32-25-server #44-Ubuntu SMP Fri Sep 17 21:13:39 UTC
2010 x86_64 GNU/Linux

date
Thu Mar 3 15:30:17 MST 2011

ls -l localtime
lrwxrwxrwx 1 root root 31 2010-10-18 08:20 localtime ->
/usr/share/zoneinfo/US/Mountain

postgres=# select * from pg_settings where name = 'TimeZone';
-[ RECORD 1 ]---------------------------------------------------------------
name | TimeZone
setting | Navajo
unit |
category | Client Connection Defaults / Locale and Formatting
short_desc | Sets the time zone for displaying and interpreting time stamps.
extra_desc |
context | user
vartype | string
source | command line
min_val |
max_val |
enumvals |
boot_val | UNKNOWN
reset_val | Navajo
sourcefile |
sourceline |

Version 8.4.7.

There is actually a time zone "Navajo", which is a *separate* time zone
from US/Mountain. Ideas on how this happened?

--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-03-03 23:03:40 Re: Mismapping of Mountain Time
Previous Message Tom Lane 2011-03-03 21:59:15 Re: Possible regression: libpq + SSL aborts when user has no home directory