From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)postgresql(dot)org |
Subject: | pgsql: Expand the allowed range of timezone offsets to +/-15:59:59 from |
Date: | 2012-05-30 23:59:30 |
Message-ID: | E1SZsna-0000i6-54@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Expand the allowed range of timezone offsets to +/-15:59:59 from Greenwich.
We used to only allow offsets less than +/-13 hours, then it was +/14,
then it was +/-15. That's still not good enough though, as per today's bug
report from Patric Bechtel. This time I actually looked through the Olson
timezone database to find the largest offsets used anywhere. The winners
are Asia/Manila, at -15:56:00 until 1844, and America/Metlakatla, at
+15:13:42 until 1867. So we'd better allow offsets less than +/-16 hours.
Given the history, we are way overdue to have some greppable #define
symbols controlling this, so make some ... and also remove an obsolete
comment that didn't get fixed the last time.
Back-patch to all supported branches.
Branch
------
REL9_1_STABLE
Details
-------
http://git.postgresql.org/pg/commitdiff/fea3ea1f23fb7f72aad28a55a09a60897a08dd3d
Modified Files
--------------
src/backend/utils/adt/date.c | 5 ++---
src/backend/utils/adt/datetime.c | 6 ++----
src/include/utils/timestamp.h | 10 ++++++++++
3 files changed, 14 insertions(+), 7 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-05-31 03:29:06 | pgsql: Ignore SECURITY DEFINER and SET attributes for a PL's call handl |
Previous Message | Robert Haas | 2012-05-30 20:23:36 | pgsql: Fix two more bugs in fast-path relation locking. |