Re: Timezones in 8.2.7

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Timezones in 8.2.7
Дата
Msg-id 29888.1206552504@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Timezones in 8.2.7  (Joseph S <jks@selectacast.net>)
Список 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 по дате отправления:

Предыдущее
От: Ben
Дата:
Сообщение: Re: Survey: renaming/removing script binaries (createdb, createuser...)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Survey: renaming/removing script binaries (createdb, createuser...)