[postgis-tickets] [SCM] PostGIS branch main updated. 3.1.0rc1-384-gf86f090

[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, main has been updated
       via  f86f090b0d4efa4b641538debab83014720baea1 (commit)
      from  b4d57be9f97d2ddba6d8508b0e6d417c87a09dea (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 f86f090b0d4efa4b641538debab83014720baea1
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Jul 31 23:48:11 2021 -0400

    Prevent _ from matching any character. References #4959 for PostGIS 3.2.0.  Mistake on last commit

diff --git a/extras/tiger_geocoder/tiger_loader_2020.sql b/extras/tiger_geocoder/tiger_loader_2020.sql
index fd4088f..6afce15 100644
--- a/extras/tiger_geocoder/tiger_loader_2020.sql
+++ b/extras/tiger_geocoder/tiger_loader_2020.sql
@@ -144,7 +144,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 '~_%' ESCAPE '~'  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;

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

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


hooks/post-receive
-- 
PostGIS