[postgis-tickets] [SCM] PostGIS branch stable-2.5 updated. 2.5.5-13-g6a093cc

git at osgeo.org git at osgeo.org
Sat Jul 31 20:46:31 PDT 2021


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  6a093ccee97505a0651418e94765f16fe6539322 (commit)
      from  1d66b61858f8786b0392e730ffa3d24163c7ec6c (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 6a093ccee97505a0651418e94765f16fe6539322
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Jul 31 23:46:24 2021 -0400

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

diff --git a/extras/tiger_geocoder/tiger_loader_2017.sql b/extras/tiger_geocoder/tiger_loader_2017.sql
index 807c136..0609e13 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 '~_%' 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_2017.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list