]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Run regression tests with timezone America/Los_Angeles.
authorTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Sep 2024 21:55:03 +0000 (17:55 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Sat, 14 Sep 2024 21:55:03 +0000 (17:55 -0400)
commit2b94ee58bf256e1b4682f21f13d0f2c73e1b0cc2
tree72dbf2f7fa4fc9836192b0ac0a014e4d04b6f589
parent17c35ab236980fce2989f7fac7cee42ca4d5ca04
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
doc/src/sgml/ref/set.sgml
doc/src/sgml/regress.sgml
src/test/regress/expected/date.out
src/test/regress/expected/horology.out
src/test/regress/expected/timestamptz.out
src/test/regress/pg_regress.c
src/test/regress/sql/horology.sql
src/test/regress/sql/timestamptz.sql