From: Tom Lane <tgl@sss.pgh.pa.us>
To: pgsql-committers@lists.postgresql.org
Subject: pgsql: Run regression tests with timezone America/Los_Angeles.
Date: Sat, 14 Sep 2024 21:55:28 +0000
Message-ID: <E1spajn-0018pX-WE@gemulon.postgresql.org> (raw)
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_12_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/205813da4c264d80db3c3215db199cc119e18369
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 | 53 ++++---
src/test/regress/expected/timestamptz.out | 249 +++++++++++++++---------------
src/test/regress/pg_regress.c | 2 +-
src/test/regress/sql/horology.sql | 4 +-
src/test/regress/sql/timestamptz.sql | 5 +-
8 files changed, 178 insertions(+), 155 deletions(-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-committers@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-committers@lists.postgresql.org
Subject: Re: pgsql: Run regression tests with timezone America/Los_Angeles.
In-Reply-To: <E1spajn-0018pX-WE@gemulon.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox