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/sgml/ref/set.sgml | |
| 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/sgml/ref/set.sgml')
| -rw-r--r-- | doc/src/sgml/ref/set.sgml | 4 |
1 files changed, 2 insertions, 2 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> |
