[postgis-tickets] [SCM] PostGIS branch stable-3.2 updated. 3.2.1-26-g10261f4d5

[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.2 has been updated
       via  10261f4d576a5120d4aa9eabf126bb380993c46b (commit)
      from  78bde131f6e0a019e49dfb927b8df131dea8aa93 (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 10261f4d576a5120d4aa9eabf126bb380993c46b
Author: Regina Obe <lr at pcorp.us>
Date:   Tue Jun 14 18:06:23 2022 -0400

    More tiger install cleanup
    Fix upgrading, was leaving out new table and table structure changes
    Fix function signature

diff --git a/doc/installation.xml b/doc/installation.xml
index 3964213f9..481bf48e1 100644
--- a/doc/installation.xml
+++ b/doc/installation.xml
@@ -1050,7 +1050,7 @@ SELECT 'debbie', declare_sect, pgbin, wget, unzip_command, psql, path_sep,
 			<listitem><para>As of PostGIS 2.4.1 the Zip code-5 digit tabulation area <varname>zcta5</varname> load step was revised to load current zcta5 data and is part of the  <xref linkend="Loader_Generate_Nation_Script" /> when enabled.
 It is turned off by default because it takes quite a bit of time to load (20 to 60 minutes), takes up quite a bit of disk space, and is not used that often.</para>
 <para>To enable it, do the following:</para>
-<programlisting>UPDATE tiger.loader_lookuptables SET load = true WHERE table_name = 'zcta510';</programlisting>
+<programlisting>UPDATE tiger.loader_lookuptables SET load = true WHERE table_name = 'zcta520';</programlisting>
 <para>
 If present the <xref linkend="Geocode" /> function can use it if a boundary filter is added to limit to just zips in that boundary.
 The <xref linkend="Reverse_Geocode" /> function uses it if the returned address is missing a zip, which often happens with highway reverse geocoding.</para></listitem>
diff --git a/extensions/postgis_tiger_geocoder/Makefile.in b/extensions/postgis_tiger_geocoder/Makefile.in
index a2cf7bded..eb04eb576 100644
--- a/extensions/postgis_tiger_geocoder/Makefile.in
+++ b/extensions/postgis_tiger_geocoder/Makefile.in
@@ -211,9 +211,7 @@ sql/$(EXTENSION)--unpackaged--$(EXTVERSION).sql: sql_bits/tiger_geocoder--unpack
 #they can be dropped but we need to remove
 #them from the extension first
 sql/tiger_geocoder_upgrade_minor.sql:  sql_bits/tiger_geocoder_minor.sql.in | sql
-	sed -e '/^\(CREATE\|ALTER\) \(CAST\|TYPE\|TABLE\|SCHEMA\|DOMAIN\|TRIGGER\).*;/d' \
-	 	 -e '/^\(CREATE\|ALTER\) \(CAST\|TYPE\|TABLE\|SCHEMA\|DOMAIN\|TRIGGER\)/,/\;/d' \
-	 	 -e 's/BEGIN;//g' -e 's/COMMIT;//g' \
+	sed -e 's/BEGIN;//g' -e 's/COMMIT;//g' \
 	 	 $< > $@
 
 EXTDIR=$(DESTDIR)$(datadir)/$(datamoduledir)
diff --git a/extras/tiger_geocoder/utility/set_search_path.sql b/extras/tiger_geocoder/utility/set_search_path.sql
index c8e8595bb..c3c35f43b 100644
--- a/extras/tiger_geocoder/utility/set_search_path.sql
+++ b/extras/tiger_geocoder/utility/set_search_path.sql
@@ -5,7 +5,7 @@
 -- 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)
+CREATE OR REPLACE FUNCTION tiger.SetSearchPathForInstall(a_schema_name text)
 RETURNS text
 AS
 $$

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

Summary of changes:
 doc/installation.xml                              | 2 +-
 extensions/postgis_tiger_geocoder/Makefile.in     | 4 +---
 extras/tiger_geocoder/utility/set_search_path.sql | 2 +-
 3 files changed, 3 insertions(+), 5 deletions(-)


hooks/post-receive
-- 
PostGIS