pgsql: Stabilize timetz test across DST transitions.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Stabilize timetz test across DST transitions.
Date: 2020-10-29 19:29:32
Message-ID: E1kYDc4-0003AU-M4@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Stabilize timetz test across DST transitions.

The timetz test cases I added in commit a9632830b were unintentionally
sensitive to whether or not DST is active in the PST8PDT time zone.
Thus, they'll start failing this coming weekend, as reported by
Bernhard M. Wiedemann in bug #16689. Fortunately, DST-awareness is
not significant to the purpose of these test cases, so we can just
force them all to PDT (DST hours) to preserve stability of the
results.

Back-patch to v10, as the prior patch was.

Discussion: https://postgr.es/m/16689-57701daa23b377bf@postgresql.org

Branch
------
REL_12_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/25b587f03a8372786ec06fbd033fdf49750be0e5

Modified Files
--------------
src/test/regress/expected/timetz.out | 32 ++++++++++++++++----------------
src/test/regress/sql/timetz.sql | 16 ++++++++--------
2 files changed, 24 insertions(+), 24 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2020-10-30 14:39:05 pgsql: Doc: clarify description for pg_constraint.convalidated.
Previous Message Tom Lane 2020-10-29 17:33:48 pgsql: Don't use custom OID symbols in pg_type.dat, either.