Re: Regarding timezone

Поиск
Список
Период
Сортировка
От Dev Kumkar
Тема Re: Regarding timezone
Дата
Msg-id CALSLE1NYXxkpUN7_t7H7C1pg6pm4cpjQHbva2msEtMv-U_2Lww@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Regarding timezone  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Regarding timezone  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
On Thu, Sep 18, 2014 at 12:01 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
The next set of minor releases, whenever those are (and no, there's
no schedule).

I hope the binaries archive containing ""pgsql/share/postgresql/
timezone/Europe/Moscow" uploaded at http://www.enterprisedb.com/products-services-training/pgbindownload will also get corrected.

It would break timezone reporting for historical Moscow timestamps, ie
they'd be printed as GMT-3 whether or not that was applicable at the time.
Don't know whether you care about that.

The column storing datetime is of type "timestamp" and timezone is not being stored. So should not be an issue for this particular use-case. For "timestamp with time zone" that was definitely an issue.
By the way won't that be issue anyways once the Moscow timezone is corrected in upgraded postgres version?

Regards...

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Regarding timezone
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Regarding timezone