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 | b27622c90869aab63cfe22159a459c57768b0fa4 (patch) | |
| tree | 879210868255f998d0bf52fdf35c74ce41a00e18 /doc/src | |
| parent | 9f77494647ded10c5ffd67cea92abcfdaea7dddd (diff) | |
| download | postgresql-b27622c90869aab63cfe22159a459c57768b0fa4.tar.gz postgresql-b27622c90869aab63cfe22159a459c57768b0fa4.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 9a7b387b29f..20ebc122bf7 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -198,7 +198,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. @@ -296,7 +296,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 98a702ef1af..47680f37688 100644 --- a/doc/src/sgml/regress.sgml +++ b/doc/src/sgml/regress.sgml @@ -556,11 +556,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> |