OBS-URL: https://build.opensuse.org/package/show/server:database:postgresql/postgresql16?expand=0&rev=39

postgresql-testsuite-timezone-fix.patch

@@ -28,47 +28,6 @@ Discussion: https://postgr.es/m/0a997455-5aba-4cf2-a354-d26d8bcbfae6@technowledg
  src/test/regress/sql/timestamptz.sql      |   5 +-
  8 files changed, 120 insertions(+), 105 deletions(-)
 
-diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
-index 5459b29525969..f0e6047e0b117 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 69f627d7f4310..6cb08f7ca825e 100644
---- a/doc/src/sgml/regress.sgml
-+++ b/doc/src/sgml/regress.sgml
-@@ -534,11 +534,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>
- 
 diff --git a/src/test/regress/expected/date.out b/src/test/regress/expected/date.out
 index f5949f3d174dd..20374c5230a7c 100644
 --- a/src/test/regress/expected/date.out