[postgis-tickets] [SCM] PostGIS branch stable-2.5 updated. 2.5.8-9-g47f59d9bc

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS".

The branch, stable-2.5 has been updated
       via  47f59d9bcc174548a2802807337f042a9b076c65 (commit)
      from  6201c2fe7ed482d59082308ef2d69c8d4f4caf08 (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit 47f59d9bcc174548a2802807337f042a9b076c65
Author: Sandro Santilli <strk at kbt.io>
Date:   Fri Nov 11 15:53:16 2022 +0100

    Do not create an ST_Union based view on upgrade (won't work)
    
    The code to support PG12 CREATE OR REPLACE AGGREGATE entered
    the code base in 3.0 so 2.5 does not support such upgrades.
    
    Closes #5287

diff --git a/regress/hooks/hook-after-upgrade.sql b/regress/hooks/hook-after-upgrade.sql
index 459f80249..e9d54585c 100644
--- a/regress/hooks/hook-after-upgrade.sql
+++ b/regress/hooks/hook-after-upgrade.sql
@@ -1,2 +1 @@
-DROP VIEW IF EXISTS upgrade_view_test;
 DROP TABLE upgrade_test;
diff --git a/regress/hooks/hook-before-upgrade.sql b/regress/hooks/hook-before-upgrade.sql
index d4bcb8cd6..6b8696529 100644
--- a/regress/hooks/hook-before-upgrade.sql
+++ b/regress/hooks/hook-before-upgrade.sql
@@ -2,25 +2,3 @@ CREATE TABLE upgrade_test(g1 geometry, g2 geography);
 INSERT INTO upgrade_test(g1,g2) VALUES
 ('POINT(0 0)', 'LINESTRING(0 0, 1 1)'),
 ('POINT(1 0)', 'LINESTRING(0 1, 1 1)');
-
--- We know upgrading with an st_union() based view
--- fails unless you're on PostgreSQL 12, so we don't
--- even try that.
---
--- We could re-enable this test IF we fix the upgrade
--- in pre-12 versions. Refer to
--- https://trac.osgeo.org/postgis/ticket/4386
---
-DO $BODY$
-DECLARE
-	vernum INT;
-BEGIN
-	show server_version_num INTO vernum;
-	IF vernum >= 120000
-	THEN
-		RAISE DEBUG '12+ server (%)', vernum;
-    CREATE VIEW upgrade_view_test AS
-    SELECT ST_Union(g1) FROM upgrade_test;
-	END IF;
-END;
-$BODY$ LANGUAGE 'plpgsql';

-----------------------------------------------------------------------

Summary of changes:
 regress/hooks/hook-after-upgrade.sql  |  1 -
 regress/hooks/hook-before-upgrade.sql | 22 ----------------------
 2 files changed, 23 deletions(-)


hooks/post-receive
-- 
PostGIS