pgsql: Don't require bleeding-edge timezone data in timestamptz regress - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Don't require bleeding-edge timezone data in timestamptz regress
Date
Msg-id E1Xqv8x-0005H9-9R@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Don't require bleeding-edge timezone data in timestamptz regression test.

The regression test cases added in commits b2cbced9e et al depended in part
on the Russian timezone offset changes of Oct 2014.  While this is of no
particular concern for a default Postgres build, it was possible for a
build using --with-system-tzdata to fail the tests if the system tzdata
database wasn't au courant.  Bjorn Munch and Christoph Berg both complained
about this while packaging 9.4rc1, so we probably shouldn't insist on the
system tzdata being up-to-date.  Instead, make an equivalent test using a
zone change that occurred in Venezuela in 2007.  With this patch, the
regression tests should pass using any tzdata set from 2012 or later.
(I can't muster much sympathy for somebody using --with-system-tzdata
on a machine whose system tzdata is more than three years out-of-date.)

Branch
------
REL9_1_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/33f642f23a34ab66e59008a6861b169e79bcf9bf

Modified Files
--------------
src/test/regress/expected/timestamptz.out |  216 +++++++++++++++--------------
src/test/regress/sql/timestamptz.sql      |  115 +++++++--------
2 files changed, 168 insertions(+), 163 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Don't require bleeding-edge timezone data in timestamptz regress
Next
From: Tom Lane
Date:
Subject: pgsql: Don't require bleeding-edge timezone data in timestamptz regress