[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0rc2-330-gb4e198bf3

[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, master has been updated
       via  b4e198bf3c6e3fb6a462930ba477c4e30d96e22f (commit)
      from  86d6b1b55bdeb71819b86a028e70c888c05c907f (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 b4e198bf3c6e3fb6a462930ba477c4e30d96e22f
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Feb 8 11:41:15 2022 +0100

    Always test upgrades in presence of ST_Union based view
    
    Even when running in PostgreSQL < 12

diff --git a/regress/hooks/hook-before-upgrade.sql b/regress/hooks/hook-before-upgrade.sql
index e5a78de74..12105de01 100644
--- a/regress/hooks/hook-before-upgrade.sql
+++ b/regress/hooks/hook-before-upgrade.sql
@@ -3,27 +3,10 @@ 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_union AS
-    SELECT ST_Union(g1) FROM upgrade_test;
-	END IF;
-END;
-$BODY$ LANGUAGE 'plpgsql';
+-- Add view using ST_Union aggregate
+-- See https://trac.osgeo.org/postgis/ticket/4386
+CREATE VIEW upgrade_view_test_union AS
+SELECT ST_Union(g1) FROM upgrade_test;
 
 -- Add view using overlay functions
 CREATE VIEW upgrade_view_test_overlay AS

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

Summary of changes:
 regress/hooks/hook-before-upgrade.sql | 25 ++++---------------------
 1 file changed, 4 insertions(+), 21 deletions(-)


hooks/post-receive
-- 
PostGIS