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
Re: We're not lax enough about maximum time zone offset from UTC |
Список | 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 по дате отправления: