[postgis-tickets] r17441 - schema qualify usage

[Regina Obe]

Author: robe
Date: 2019-05-25 17:59:07 -0700 (Sat, 25 May 2019)
New Revision: 17441

Modified:
   trunk/extras/tiger_geocoder/tiger_loader_2018.sql
Log:
schema qualify usage

Modified: trunk/extras/tiger_geocoder/tiger_loader_2018.sql
===================================================================
--- trunk/extras/tiger_geocoder/tiger_loader_2018.sql	2019-05-21 23:56:47 UTC (rev 17440)
+++ trunk/extras/tiger_geocoder/tiger_loader_2018.sql	2019-05-26 00:59:07 UTC (rev 17441)
@@ -455,7 +455,7 @@
 ' || replace(platform.unzip_command, '*.zip', 'tl_*_' || s.state_fips || '*_' || table_name || '*.zip ') || '
 ' || loader_macro_replace(COALESCE(lu.pre_load_process || E'\n', '') || COALESCE(county_process_command || E'\n','')
 				|| COALESCE(E'\n' ||lu.post_load_process , '') , ARRAY['loader','table_name','lookup_name'], ARRAY[platform.loader  || ' -D ' || CASE WHEN lu.single_geom_mode THEN ' -S' ELSE ' ' END::text, lu.table_name, lu.lookup_name ])
-				FROM loader_lookuptables AS lu
+				FROM tiger.loader_lookuptables AS lu
 				WHERE level_county = true AND load = true
 				ORDER BY process_order, lookup_name), E'\n') ::text
 	, ARRAY['psql', 'data_schema','staging_schema', 'staging_fold', 'state_fold', 'website_root', 'state_abbrev','state_fips'],