[SCM] PostGIS branch stable-3.4 updated. 3.4.1-25-ga7b38eac8

[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-3.4 has been updated
       via  a7b38eac8e8071d0407c2106ca5a0252c6e31012 (commit)
       via  28a10ec44646622d53bca64117e49ea8c48ce620 (commit)
      from  35da0957f6b1f6e7d3024faf09a527c5e4dcf6f4 (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 a7b38eac8e8071d0407c2106ca5a0252c6e31012
Author: Sandro Santilli <strk at kbt.io>
Date:   Mon Oct 30 19:13:59 2023 +0100

    Give more detail about unexpected functions ownership

diff --git a/regress/core/regress.sql b/regress/core/regress.sql
index 49f4c607a..e2a52a7b3 100644
--- a/regress/core/regress.sql
+++ b/regress/core/regress.sql
@@ -341,8 +341,14 @@ ORDER BY 2;
 
 -- Make sure all postgis functions are owned by the
 -- same role as postgis_lib_version
-SELECT DISTINCT 'unexpected ownership', oid::regprocedure,  proowner::regrole
-FROM pg_proc
+SELECT DISTINCT
+	'unexpected ownership: ' || oid::regprocedure ||
+	' is owned by ' ||  proowner::regrole ||
+	' instead of ' || (
+			SELECT proowner::regrole FROM pg_proc
+			WHERE proname = 'postgis_lib_version'
+	)
+	FROM pg_proc
 WHERE (
 	probin like '%postgis%'
   OR (
@@ -357,7 +363,7 @@ AND proowner !=
 	proowner
 	FROM pg_proc WHERE proname = 'postgis_lib_version'
 )
-ORDER BY 2;
+ORDER BY 1;
 
 -- Make sure all postgis functions are SECURITY INVOKER
 SELECT DISTINCT 'unexpected security definer', oid::regprocedure, prosecdef

commit 28a10ec44646622d53bca64117e49ea8c48ce620
Author: Sandro Santilli <strk at kbt.io>
Date:   Wed Dec 27 10:48:54 2023 +0100

    More escaped string usage (regress tests)
    
    References #5633

diff --git a/regress/core/regress.sql b/regress/core/regress.sql
index 62de3563d..49f4c607a 100644
--- a/regress/core/regress.sql
+++ b/regress/core/regress.sql
@@ -330,11 +330,11 @@ SELECT DISTINCT 'unexpected probin', proname || ':' || probin
 FROM pg_proc
 WHERE probin like '%postgis%'
   AND
-regexp_replace(probin, '(rt)?postgis(_[^-]*)?(-[0-9.]*)$', '\3')
+regexp_replace(probin, '(rt)?postgis(_[^-]*)?(-[0-9.]*)$', E'\\3')
 	!=
 (
 	SELECT
-regexp_replace(probin, '(rt)?postgis(_[^-]*)?(-[0-9.]*)$', '\3')
+regexp_replace(probin, '(rt)?postgis(_[^-]*)?(-[0-9.]*)$', E'\\3')
 	FROM pg_proc WHERE proname = 'postgis_lib_version'
 )
 ORDER BY 2;
@@ -347,7 +347,7 @@ WHERE (
 	probin like '%postgis%'
   OR (
 		probin is null and
-		oid::regprocedure::text like 'st\_%' or
+		oid::regprocedure::text like E'st\\_%' or
 		oid::regprocedure::text like 'postgis_%'
 	)
 )
@@ -366,7 +366,7 @@ WHERE (
 	probin like '%postgis%'
   OR (
 		probin is null and
-		oid::regprocedure::text like 'st\_%' or
+		oid::regprocedure::text like E'st\\_%' or
 		oid::regprocedure::text like 'postgis_%'
 	)
 )

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

Summary of changes:
 regress/core/regress.sql | 20 +++++++++++++-------
 1 file changed, 13 insertions(+), 7 deletions(-)


hooks/post-receive
-- 
PostGIS