We're not lax enough about maximum time zone offset from UTC

Поиск
Список
Период
Сортировка
От Tom Lane
Тема We're not lax enough about maximum time zone offset from UTC
Дата
Msg-id 10520.1338415812@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: We're not lax enough about maximum time zone offset from UTC  ("David E. Wheeler" <david@justatheory.com>)
Re: We're not lax enough about maximum time zone offset from UTC  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
Currently, our datetime input code thinks that any UTC offset of more
than 14:59:59 either way from Greenwich must be a mistake.  However,
after seeing Patric Bechtel's recent bug report, I went trolling in the
Olson timezone files to see what are the largest offsets used there.
I found three entries that are further out than that:

# Zone    NAME        GMTOFF    RULES    FORMAT    [UNTIL]
Zone Asia/Manila    -15:56:00 -    LMT    1844 Dec 31
Zone America/Juneau     15:02:19 -    LMT    1867 Oct 18
Zone America/Metlakatla     15:13:42 -    LMT    1867 Oct 18

These are all ancient history of course; it does not appear that any
zones *currently* use offsets larger than +/- 14 hours, which if memory
serves is what we considered when we set the existing sanity limit.

However, as pointed out by Patric, if you dump and restore an old
timestamptz value in one of these zones, it will fail to restore because
of the sanity check.  I think therefore that we'd better enlarge the
allowed range to 15:59:59 either way.
        regards, tom lane


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Early hint bit setting
Следующее
От: Robert Haas
Дата:
Сообщение: patch: avoid heavyweight locking on hash metapage