Re: Timezones in 8.2.7 - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Timezones in 8.2.7
Date
Msg-id dcc563d10803260950sb9a886ne18159e7d44c03f2@mail.gmail.com
Whole thread Raw
In response to Re: Timezones in 8.2.7  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timezones in 8.2.7  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Mar 25, 2008 at 5:39 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Joseph S <jks@selectacast.net> writes:
>  > Was there something wrong with the tzdata distributed in 8.2.7?
>  > current_timestamp is still using EST, but the date command run from the
>  > command line is correctly returning EDT
>
>  Works for me ... what have you got TimeZone set to?

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.

My OS is set to Denver, but was set to Chicago before that.  Am
running ubuntu 7.10.

No idea if this is normal.  But seeing as this is a laptop and it got
the DST change right I'm not really worried about.  Just thought I'd
post it in this thread in case it looks worse to you than it does to
me...

pgsql-general by date:

Previous
From: "Joey K."
Date:
Subject: Fwd: Survey: renaming/removing script binaries (createdb, createuser...)
Next
From: björn lundin
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)