Re: Timezones in 8.2.7 - Mailing list pgsql-general

From Tom Lane
Subject Re: Timezones in 8.2.7
Date
Msg-id 29888.1206552504@sss.pgh.pa.us
Whole thread Raw
In response to Timezones in 8.2.7  (Joseph S <jks@selectacast.net>)
List pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:
> Sorry, I didn't realize what you were asking.
> [local]:owl=# SHOW TimeZone;
>   TimeZone
> ----------
>   EST5EDT
> (1 row)

[ squint... ]  That should certainly think that we're into DST;
it does here:

regression=# set timezone = 'EST5EDT';
SET
regression=# select now();
              now
-------------------------------
 2008-03-26 13:25:22.088717-04
(1 row)

The only thing I can think is that the copy of the timezone data file
you have in your Postgres installation is several years old and predates
the law change.  Did you check the stuff under $SHAREDIR/timezone?
(pg_config --sharedir will tell you what SHAREDIR is)

            regards, tom lane

pgsql-general by date:

Previous
From: Ben
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Next
From: Alvaro Herrera
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)