Horton

Run regression tests with timezone America/Los_Angeles.

Tom Lane <tgl@sss.pgh.pa.us>

View on postgr.es
Commit: b27622c90869aab63cfe22159a459c57768b0fa4
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2024-09-14T21:55:03Z
Releases: 14.14 
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

Files

PathChange+/−
doc/src/sgml/ref/set.sgml modified +2 −2
doc/src/sgml/regress.sgml modified +3 −3
src/test/regress/expected/date.out modified +5 −5
src/test/regress/expected/horology.out modified +31 −26
src/test/regress/expected/timestamptz.out modified +72 −65
src/test/regress/pg_regress.c modified +1 −1
src/test/regress/sql/horology.sql modified +2 −2
src/test/regress/sql/timestamptz.sql modified +4 −1

Documentation touched

Discussion