[postgis-tickets] [SCM] PostGIS branch stable-2.5 updated. 2.5.5-12-g1d66b61

[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-2.5 has been updated
       via  1d66b61858f8786b0392e730ffa3d24163c7ec6c (commit)
      from  f793a885dce838862ce0e6ef00ff1b7faba8efda (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 1d66b61858f8786b0392e730ffa3d24163c7ec6c
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Jul 31 23:44:20 2021 -0400

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

diff --git a/extras/tiger_geocoder/tiger_loader_2017.sql b/extras/tiger_geocoder/tiger_loader_2017.sql
index ea520c6..807c136 100644
--- a/extras/tiger_geocoder/tiger_loader_2017.sql
+++ b/extras/tiger_geocoder/tiger_loader_2017.sql
@@ -123,7 +123,7 @@ 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 '~_%' ESCAPE '~'  ORDER BY table_name) AS foo;
 ;
 $$
   LANGUAGE sql VOLATILE;

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

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


hooks/post-receive
-- 
PostGIS