diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2024-09-14 17:55:02 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2024-09-14 17:55:02 -0400 |
| commit | b8ea0f675f35c3f0c2cf62175517ba0dacad4abd (patch) | |
| tree | 2e1fa6fe38bb2682468e35c9cc58b38d08f86193 /doc/src | |
| parent | f64074c88c067b4733ae439afae46ad61e45474b (diff) | |
| download | postgresql-b8ea0f675f35c3f0c2cf62175517ba0dacad4abd.tar.gz postgresql-b8ea0f675f35c3f0c2cf62175517ba0dacad4abd.zip | |
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 d1042e02228..f4cef9e80f7 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -576,11 +576,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> |