[postgis-tickets] [SCM] PostGIS branch master updated. 3.3.0beta1-27-g7373f4a42

[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  7373f4a42bf282f0987155ce8d5ab592bcc1c9b4 (commit)
      from  375224ac689a928aeac35533daffb4f6f3fe20e6 (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 7373f4a42bf282f0987155ce8d5ab592bcc1c9b4
Author: Sandro Santilli <strk at kbt.io>
Date:   Tue Jul 12 08:18:48 2022 +0200

    Check for ownership mismatch in regress test

diff --git a/regress/core/regress.sql b/regress/core/regress.sql
index d22c7063f..17982981e 100644
--- a/regress/core/regress.sql
+++ b/regress/core/regress.sql
@@ -339,6 +339,26 @@ regexp_replace(probin, '(rt)?postgis(_[^-]*)?(-[0-9.]*)$', '\3')
 )
 ORDER BY 2;
 
+-- Make sure all postgis functions are owned by the
+-- same role as postgis_lib_version
+SELECT DISTINCT 'unexpected ownership', proname || ':' || proowner::regrole
+FROM pg_proc
+WHERE (
+	probin like '%postgis%'
+  OR (
+		probin is null and
+		oid::regprocedure::text like 'st\_%' or
+		oid::regprocedure::text like 'postgis_%'
+	)
+)
+AND proowner !=
+(
+	SELECT
+	proowner
+	FROM pg_proc WHERE proname = 'postgis_lib_version'
+)
+ORDER BY 2;
+
 
 SELECT 'UNEXPECTED', postgis_full_version()
 	WHERE postgis_full_version() LIKE '%UNPACKAGED%'

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

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


hooks/post-receive
-- 
PostGIS