[SCM] PostGIS branch master updated. 3.4.0rc1-731-g72e683a7c

[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  72e683a7c911e78eb4221bd677149c92438c79d0 (commit)
       via  ac2822563998f06db0e014cec85d1cc809fd9523 (commit)
      from  232d08c8cd746bd4afb4089e46d7566ffac0a7f7 (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 72e683a7c911e78eb4221bd677149c92438c79d0
Author: Sandro Santilli <strk at kbt.io>
Date:   Fri Oct 27 11:29:32 2023 +0200

    Provide a script to configure pgextwlist
    
    Reference #5566 in master branch (3.5.0dev)

diff --git a/regress/hooks/configure-pgextwlist.sql b/regress/hooks/configure-pgextwlist.sql
new file mode 100644
index 000000000..1e1b756e5
--- /dev/null
+++ b/regress/hooks/configure-pgextwlist.sql
@@ -0,0 +1,21 @@
+DO $SANDBOX$
+BEGIN
+
+	EXECUTE format(
+		$$
+			ALTER DATABASE %I
+			SET session_preload_libraries = 'pgextwlist.so'
+		$$,
+		current_database()
+	);
+
+	EXECUTE format(
+		$$
+			ALTER DATABASE %I
+			SET extwlist.extensions='postgis,postgis_raster,postgis_topology,postgis_sfcgal,address_standardizer,postgis_tiger_geocoder'
+		$$,
+		current_database()
+	);
+
+END;
+$SANDBOX$ LANGUAGE 'plpgsql';

commit ac2822563998f06db0e014cec85d1cc809fd9523
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 62de3563d..3ea0fc15e 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 (

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

Summary of changes:
 regress/core/regress.sql               | 10 ++++++++--
 regress/hooks/configure-pgextwlist.sql | 21 +++++++++++++++++++++
 2 files changed, 29 insertions(+), 2 deletions(-)
 create mode 100644 regress/hooks/configure-pgextwlist.sql


hooks/post-receive
-- 
PostGIS