diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-09-14 17:55:03 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-09-14 17:55:03 -0400 |
| commit | 2b94ee58bf256e1b4682f21f13d0f2c73e1b0cc2 (patch) | |
| tree | 72dbf2f7fa4fc9836192b0ac0a014e4d04b6f589 /doc/src | |
| parent | 17c35ab236980fce2989f7fac7cee42ca4d5ca04 (diff) | |
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
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/regress.sgml | 6 |
2 files changed, 5 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 5459b295259..f0e6047e0b1 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -200,7 +200,7 @@ SELECT setseed(<replaceable>value</replaceable>); <variablelist> <varlistentry> - <term><literal>'PST8PDT'</literal></term> + <term><literal>'America/Los_Angeles'</literal></term> <listitem> <para> The time zone for Berkeley, California. @@ -298,7 +298,7 @@ SET datestyle TO postgres, dmy; <para> Set the time zone for Berkeley, California: <screen> -SET TIME ZONE 'PST8PDT'; +SET TIME ZONE 'America/Los_Angeles'; </screen> </para> diff --git a/doc/src/sgml/regress.sgml b/doc/src/sgml/regress.sgml index ec50efa20a3..aa380c20de6 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -521,11 +521,11 @@ make check NO_LOCALE=1 <para> Most of the date and time results are dependent on the time zone environment. The reference files are generated for time zone - <literal>PST8PDT</literal> (Berkeley, California), and there will be + <literal>America/Los_Angeles</literal>, and there will be apparent failures if the tests are not run with that time zone setting. The regression test driver sets environment variable - <envar>PGTZ</envar> to <literal>PST8PDT</literal>, which normally - ensures proper results. + <envar>PGTZ</envar> to <literal>America/Los_Angeles</literal>, + which normally ensures proper results. </para> </sect2> |