Accepting request 1240820 from server:database:postgresql

- Fix build, add postgresql-tzdata2025a.patch

OBS-URL: https://build.opensuse.org/request/show/1240820
OBS-URL: https://build.opensuse.org/package/show/openSUSE:Factory/postgresql16?expand=0&rev=13

postgresql-tzdata2025a.patch

@@ -0,0 +1,26 @@
+--- src/test/regress/expected/timestamptz.out.orig
++++ src/test/regress/expected/timestamptz.out
+@@ -2388,10 +2388,10 @@ SELECT make_timestamptz(2014, 12, 10, 0,
+  Tue Dec 09 23:00:00 2014
+ (1 row)
+ 
+-SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC';
++SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Asia/Singapore') AT TIME ZONE 'UTC';
+          timezone         
+ --------------------------
+- Wed Dec 09 15:56:00 1846
++ Fri Dec 09 17:04:35 1881
+ (1 row)
+ 
+ SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC';
+--- src/test/regress/sql/timestamptz.sql.orig
++++ src/test/regress/sql/timestamptz.sql
+@@ -442,7 +442,7 @@ SELECT make_timestamptz(1973, 07, 15, 08
+ -- full timezone names
+ SELECT make_timestamptz(2014, 12, 10, 0, 0, 0, 'Europe/Prague') = timestamptz '2014-12-10 00:00:00 Europe/Prague';
+ SELECT make_timestamptz(2014, 12, 10, 0, 0, 0, 'Europe/Prague') AT TIME ZONE 'UTC';
+-SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC';
++SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Asia/Singapore') AT TIME ZONE 'UTC';
+ SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC';
+ SELECT make_timestamptz(1910, 12, 24, 0, 0, 0, 'Nehwon/Lankhmar');
+ 

postgresql16.changes

@@ -1,3 +1,8 @@
+-------------------------------------------------------------------
+Tue Jan 28 12:23:29 UTC 2025 - Reinhard Max <max@suse.com>
+
+- Fix build, add postgresql-tzdata2025a.patch
+
 -------------------------------------------------------------------
 Tue Nov 19 14:31:22 UTC 2024 - Reinhard Max <max@suse.com>
 

postgresql16.spec

@@ -1,7 +1,7 @@
 #
 # spec file for package postgresql16
 #
-# Copyright (c) 2024 SUSE LLC
+# Copyright (c) 2025 SUSE LLC
 #
 # All modifications and additions to the file contributed by third parties
 # remain the property of their copyright owners, unless otherwise agreed
@@ -190,6 +190,7 @@ Patch9:         postgresql-var-run-socket.patch
 Patch10:        postgresql-llvm-optional.patch
 Patch11:        0001-jit-Workaround-potential-datalayout-mismatch-on-s390.patch
 %endif
+Patch12:        postgresql-tzdata2025a.patch
 URL:            https://www.postgresql.org/
 BuildRoot:      %{_tmppath}/%{name}-%{version}-build
 Provides:       postgresql = %version-%release
@@ -523,6 +524,7 @@ touch -r configure tmp
 %if %{with llvm}
 %patch -P 10
 %patch -P 11
+%patch -P 12
 %endif
 touch -r tmp configure
 rm tmp