[postgis-tickets] [SCM] PostGIS branch master updated. 3.2.0-867-g216aca648

[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  216aca6483a2fa65a33b488e103c1188c4ade878 (commit)
      from  9f074a348926da7a66f5d5f7b01e8503c0079494 (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 216aca6483a2fa65a33b488e103c1188c4ade878
Author: Regina Obe <lr at pcorp.us>
Date:   Fri May 20 11:37:22 2022 -0400

    Fix some schema quals. References #5155 for PostGIS 3.3.0

diff --git a/extensions/postgis_extension_helper.sql b/extensions/postgis_extension_helper.sql
index 4d9b19538..e5546327e 100644
--- a/extensions/postgis_extension_helper.sql
+++ b/extensions/postgis_extension_helper.sql
@@ -85,7 +85,7 @@ CREATE FUNCTION postgis_extension_drop_if_exists(param_extension text, param_sta
   RETURNS boolean AS
 $$
 DECLARE
-	var_sql_ext text := 'ALTER EXTENSION ' || pg_catalog.quote_ident(param_extension) || ' ' || replace(param_statement, 'IF EXISTS', '');
+	var_sql_ext text := 'ALTER EXTENSION ' || pg_catalog.quote_ident(param_extension) || ' ' || pg_catalog.replace(param_statement, 'IF EXISTS', '');
 	var_result boolean := false;
 BEGIN
 	BEGIN
@@ -111,7 +111,7 @@ DECLARE
 BEGIN
 
 	WITH settings AS (
-		SELECT unnest(setconfig) config
+		SELECT pg_catalog.unnest(setconfig) config
 		FROM pg_catalog.pg_db_role_setting
 		WHERE setdatabase = (
 			SELECT oid
@@ -119,7 +119,7 @@ BEGIN
 			WHERE datname = current_database()
 		) and setrole = 0
 	)
-	SELECT regexp_replace(config, '^search_path=', '')
+	SELECT pg_catalog.regexp_replace(config, '^search_path=', '')
 	FROM settings WHERE config like 'search_path=%'
 	INTO var_cur_search_path;
 

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

Summary of changes:
 extensions/postgis_extension_helper.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)


hooks/post-receive
-- 
PostGIS