[postgis-tickets] [SCM] PostGIS branch master updated. 3.4.0rc1-71-g08aaa880a

[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  08aaa880ac8ce4ccd6e8c6eb62f851691ec65385 (commit)
      from  56368ceddf1a2c35122f5c68cf8f8445f18546a7 (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 08aaa880ac8ce4ccd6e8c6eb62f851691ec65385
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Aug 29 23:23:09 2023 +0200

    Really fix creation of the all-function locking view

diff --git a/regress/hooks/use-all-functions.sql b/regress/hooks/use-all-functions.sql
index c195f037a..46a24bb5a 100644
--- a/regress/hooks/use-all-functions.sql
+++ b/regress/hooks/use-all-functions.sql
@@ -2,6 +2,7 @@ DO $BODY$
 DECLARE
 	rec RECORD;
 BEGIN
+	DROP VIEW IF EXISTS postgis_locking_view;
 	FOR rec IN
 		SELECT
 			array_agg(
@@ -20,7 +21,7 @@ BEGIN
 				)
 				||
 				CASE WHEN prokind = 'w' THEN ' OVER()' ELSE '' END
-				|| ' as f' || oid
+				|| '::text as f' || oid
 			) f
 		FROM pg_catalog.pg_proc
 		WHERE proname like 'st\_%'
@@ -31,7 +32,9 @@ BEGIN
 		-- We skip functions taking anyelement for now
 		-- as those ones would need us to cast to some
 		-- real type
-		AND proname in ( 'st_asmvt' )
+		AND proname NOT IN ( 'st_asmvt', 'st_fromflatgeobuf' )
+		-- We skip functions using VARIADIC or OUTPUT arguments
+		AND ( NOT coalesce(proargmodes, '{}') && ARRAY['v'::"char",'o'] )
 	LOOP
 		EXECUTE format(
 			'CREATE VIEW postgis_locking_view AS SELECT %s',

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

Summary of changes:
 regress/hooks/use-all-functions.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)


hooks/post-receive
-- 
PostGIS