[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-80-g27974085d

[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  27974085d757e4f56a4f9a5c9956e40acd403829 (commit)
      from  148267b3d26d7777f814cea4b7cb8743026e580c (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 27974085d757e4f56a4f9a5c9956e40acd403829
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Aug 30 14:43:47 2023 +0200

    Drop any deprecated_by_postgis function after upgrade test
    
    Fixes `make -C regress/ check-locked-upgrade` for real
    
    References #5497

diff --git a/regress/hooks/hook-after-upgrade.sql b/regress/hooks/hook-after-upgrade.sql
index dfa5fc3eb..ef6ea0d15 100644
--- a/regress/hooks/hook-after-upgrade.sql
+++ b/regress/hooks/hook-after-upgrade.sql
@@ -10,22 +10,20 @@ DROP VIEW IF EXISTS upgrade_view_test_clusterkmeans;
 DROP VIEW IF EXISTS upgrade_view_test_distance;
 DROP TABLE upgrade_test;
 
+-- Drop any upgrade test data
 DROP SCHEMA IF EXISTS postgis_upgrade_test_data CASCADE;
 
 -- Drop functions deprecated on upgrade
-DROP FUNCTION IF EXISTS st_force3dz_deprecated_by_postgis_301(geometry);
-DROP FUNCTION IF EXISTS st_force3d_deprecated_by_postgis_301(geometry);
-DROP FUNCTION IF EXISTS st_force3dm_deprecated_by_postgis_301(geometry);
-DROP FUNCTION IF EXISTS st_force4d_deprecated_by_postgis_301(geometry);
-DROP FUNCTION IF EXISTS st_intersection_deprecated_by_postgis_301(geometry,geometry);
-DROP FUNCTION IF EXISTS st_difference_deprecated_by_postgis_301(geometry,geometry);
-DROP FUNCTION IF EXISTS st_symdifference_deprecated_by_postgis_301(geometry,geometry);
-DROP FUNCTION IF EXISTS st_unaryunion_deprecated_by_postgis_301(geometry);
-DROP FUNCTION IF EXISTS st_subdivide_deprecated_by_postgis_301(geometry,integer);
-DROP FUNCTION IF EXISTS st_askml_deprecated_by_postgis_200(geometry,integer);
-DROP FUNCTION IF EXISTS st_askml_deprecated_by_postgis_200(geography,integer);
-DROP FUNCTION IF EXISTS st_dwithin_deprecated_by_postgis_300(geography,geography,float8);
-DROP FUNCTION IF EXISTS st_dwithin_deprecated_by_postgis_300(text,text,float8);
-DROP FUNCTION IF EXISTS st_clusterkmeans_deprecated_by_postgis_302(geometry,integer);
-DROP FUNCTION IF EXISTS st_distance_deprecated_by_postgis_300(geography,geography);
-
+DO LANGUAGE 'plpgsql' $DROPALL$
+DECLARE
+	rec pg_catalog.pg_proc;
+BEGIN
+	FOR rec IN
+		SELECT * FROM pg_catalog.pg_proc
+		WHERE proname ~ '_deprecated_by_postgis'
+	LOOP
+		RAISE NOTICE 'Dropping function %', rec.oid::regprocedure;
+		EXECUTE pg_catalog.format('DROP FUNCTION %s', rec.oid::regprocedure);
+	END LOOP;
+END;
+$DROPALL$;

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

Summary of changes:
 regress/hooks/hook-after-upgrade.sql | 30 ++++++++++++++----------------
 1 file changed, 14 insertions(+), 16 deletions(-)


hooks/post-receive
-- 
PostGIS