From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
Subject: | pgsql: Run regression tests with timezone America/Los_Angeles. |
Date: | 2024-09-14 21:55:28 |
Message-ID: | E1spajn-0018pT-VT@gemulon.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-committers |
Run regression tests with timezone America/Los_Angeles.
Historically we've used timezone "PST8PDT", but the recent release
2024b of tzdb changes the definition of that zone in a way that
breaks many test cases concerned with dates before 1970. Although
we've not yet adopted 2024b into our own tree, this is already
problematic for people using --with-system-tzdata if their platform
has already adopted 2024b. To work with both older and newer
versions of tzdb, switch to using "America/Los_Angeles", accepting
the ensuing changes in regression test results.
Back-patch to all supported branches.
Per report and patch from Wolfgang Walther.
Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledgy.de
Branch
------
REL_14_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/b27622c90869aab63cfe22159a459c57768b0fa4
Modified Files
--------------
doc/src/sgml/ref/set.sgml | 4 +-
doc/src/sgml/regress.sgml | 6 +-
src/test/regress/expected/date.out | 10 +--
src/test/regress/expected/horology.out | 57 +++++++------
src/test/regress/expected/timestamptz.out | 137 ++++++++++++++++--------------
src/test/regress/pg_regress.c | 2 +-
src/test/regress/sql/horology.sql | 4 +-
src/test/regress/sql/timestamptz.sql | 5 +-
8 files changed, 120 insertions(+), 105 deletions(-)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2024-09-14 23:52:21 | pgsql: doc PG relnotes: add attribution for time zone data files items |
Previous Message | Alvaro Herrera | 2024-09-14 18:18:36 | pgsql: Add commit 7229ebe011df to .git-blame-ignore-revs. |