Skip site navigation (1) Skip section navigation (2)

pgsql: Expand the allowed range of timezone offsets to +/-15:59:59from

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:59from
Date: 2012-05-30 23:59:30
Message-ID: E1SZsna-0000iB-7Y@gemulon.postgresql.org (view raw or flat)
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
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/f5c5e7497b6057151936313d0cdb6cc8dc159331

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(-)

pgsql-committers by date

Next:From: Tom LaneDate: 2012-05-31 03:29:06
Subject: pgsql: Ignore SECURITY DEFINER and SET attributes for a PL's callhandl
Previous:From: Robert HaasDate: 2012-05-30 20:23:36
Subject: pgsql: Fix two more bugs in fast-path relation locking.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group