summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/set.sgml
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2024-09-14 17:55:03 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2024-09-14 17:55:03 -0400
commit2b94ee58bf256e1b4682f21f13d0f2c73e1b0cc2 (patch)
tree72dbf2f7fa4fc9836192b0ac0a014e4d04b6f589 /doc/src/sgml/ref/set.sgml
parent17c35ab236980fce2989f7fac7cee42ca4d5ca04 (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.sgml4
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>