[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-69-g80064b75c

[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  80064b75c6cbef9d54ed8bcbf93984eeb884bd61 (commit)
      from  9691b2b2efd64d2303b42329360f0a8a14345afa (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 80064b75c6cbef9d54ed8bcbf93984eeb884bd61
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Aug 29 22:13:52 2023 +0200

    Add query creating a view using all postgis functions
    
    This is meant to be used to test upgrades in a more complete way.
    It's a work in progress but the idea is it will possibly be used
    for upgrade testing, which is already possible with a call like:
    
      cat regress/hooks/use-all-functions.sql |
      make check-regress \
        RUNTESTFLAGS="--upgrade --before-upgrade-script /dev/stdin -v" \
        TESTS=$PWD/regress/core/regress.sql

diff --git a/regress/hooks/use-all-functions.sql b/regress/hooks/use-all-functions.sql
new file mode 100644
index 000000000..b4db13ca4
--- /dev/null
+++ b/regress/hooks/use-all-functions.sql
@@ -0,0 +1,30 @@
+DO $BODY$
+DECLARE
+	rec RECORD;
+BEGIN
+	FOR rec IN
+		SELECT
+			array_agg(
+				regexp_replace(
+					regexp_replace(
+						oid::regprocedure::text,
+						'\(([^)])',
+						'(NULL::\1'
+					),
+					',',
+					',NULL::',
+					'g'
+				) || ' as f' || oid
+			) f
+		FROM pg_catalog.pg_proc
+		WHERE proname like 'st\_%'
+	LOOP
+		EXECUTE format(
+			'CREATE VIEW postgis_locking_view AS SELECT %s',
+			array_to_string(rec.f, ',')
+		);
+	END LOOP;
+
+
+END;
+$BODY$ LANGUAGE 'plpgsql';

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

Summary of changes:
 regress/hooks/use-all-functions.sql | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)
 create mode 100644 regress/hooks/use-all-functions.sql


hooks/post-receive
-- 
PostGIS