[postgis-tickets] [SCM] PostGIS branch stable-3.1 updated. 3.1.5-20-g9fe244174

[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.1 has been updated
       via  9fe2441742038ca71643807858f7f3ffd497109d (commit)
      from  39ce9ea3cef3d43a2dc7ca6775ee461bdfba7fe9 (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 9fe2441742038ca71643807858f7f3ffd497109d
Author: Regina Obe <lr at pcorp.us>
Date:   Mon Jun 20 18:41:13 2022 -0400

    Change signature of search_path for tiger

diff --git a/extras/tiger_geocoder/utility/set_search_path.sql b/extras/tiger_geocoder/utility/set_search_path.sql
index 19d2f9523..764e5a3fb 100644
--- a/extras/tiger_geocoder/utility/set_search_path.sql
+++ b/extras/tiger_geocoder/utility/set_search_path.sql
@@ -5,7 +5,8 @@
 -- Adds a schema to  the front of search path so that functions, tables etc get installed by default in set schema
 -- but if people have postgis and other things installed in non-public, it will still keep those in path
 -- Example usage: SELECT tiger.SetSearchPathForInstall('tiger');
-CREATE OR REPLACE FUNCTION tiger.SetSearchPathForInstall(a_schema_name varchar)
+DROP FUNCTION IF EXISTS tiger.SetSearchPathForInstall(a_schema_name varchar);
+CREATE OR REPLACE FUNCTION tiger.SetSearchPathForInstall(a_schema_name text)
 RETURNS text
 AS
 $$

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

Summary of changes:
 extras/tiger_geocoder/utility/set_search_path.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS