[postgis-tickets] [SCM] PostGIS branch stable-3.0 updated. 3.0.3-36-gd366152

[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.0 has been updated
       via  d3661524b14a183a4b8feed91d8817a388a7f4ec (commit)
      from  c07bff365eb5081032b05a76800283939ed9e249 (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 d3661524b14a183a4b8feed91d8817a388a7f4ec
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Jul 31 23:50:25 2021 -0400

    Prevent _ from matching any character. References #4959 for PostGIS 3.0.4.

diff --git a/extras/tiger_geocoder/tiger_loader_2019.sql b/extras/tiger_geocoder/tiger_loader_2019.sql
index 12a395b..3fce651 100644
--- a/extras/tiger_geocoder/tiger_loader_2019.sql
+++ b/extras/tiger_geocoder/tiger_loader_2019.sql
@@ -123,11 +123,12 @@ CREATE OR REPLACE FUNCTION drop_state_tables_generate_script(param_state text, p
 $$
 SELECT array_to_string(array_agg('DROP TABLE ' || quote_ident(table_schema) || '.' || quote_ident(table_name) || ';'),E'\n')
 	FROM (SELECT * FROM information_schema.tables
-	WHERE table_schema = $2 AND table_name like lower($1) || '_%' ORDER BY table_name) AS foo;
+	WHERE table_schema = $2 AND table_name like lower($1) || '~_%' ESCAPE '~' ORDER BY table_name) AS foo;
 ;
 $$
   LANGUAGE sql VOLATILE;
 
+
 -- Helper function that generates script to drop all nation tables (county, state) in a particular schema
 -- This is useful for loading 2011 because state and county tables aren't broken out into separate state files
 DROP FUNCTION IF EXISTS drop_national_tables_generate_script(text);

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

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


hooks/post-receive
-- 
PostGIS