[postgis-tickets] r15294 - Turn off loading of tabblock by default. It's been broken since 2014 and not used by the geocoder

[Regina Obe]

Author: robe
Date: 2017-01-25 15:46:00 -0800 (Wed, 25 Jan 2017)
New Revision: 15294

Modified:
   trunk/extras/tiger_geocoder/tiger_loader_2016.sql
Log:
Turn off loading of tabblock by default.  It's been broken since 2014 and not used by the geocoder
References #3698 for PostGIS 2.4

Modified: trunk/extras/tiger_geocoder/tiger_loader_2016.sql
===================================================================
--- trunk/extras/tiger_geocoder/tiger_loader_2016.sql	2017-01-25 23:42:12 UTC (rev 15293)
+++ trunk/extras/tiger_geocoder/tiger_loader_2016.sql	2017-01-25 23:46:00 UTC (rev 15294)
@@ -263,7 +263,7 @@
 	${psql} -c "ALTER TABLE ${data_schema}.${state_abbrev}_${lookup_name} ADD CONSTRAINT chk_statefp CHECK (statefp = ''${state_fips}'');"', ARRAY['gid']);
 
 INSERT INTO loader_lookuptables(process_order, lookup_name, table_name, load, level_county, level_state, single_geom_mode, insert_mode, pre_load_process, post_load_process, columns_exclude )
-VALUES(11, 'tabblock', 'tabblock', true, false, true,false, 'c',
+VALUES(11, 'tabblock', 'tabblock', false, false, true,false, 'c',
 '${psql} -c "CREATE TABLE ${data_schema}.${state_abbrev}_${lookup_name}(CONSTRAINT pk_${state_abbrev}_${lookup_name} PRIMARY KEY (tabblock_id)) INHERITS(tiger.${lookup_name});" ',
 '${psql} -c "ALTER TABLE ${staging_schema}.${state_abbrev}_${lookup_name} RENAME geoid10 TO tabblock_id;"
 ${psql} -c "ALTER TABLE ${data_schema}.${state_abbrev}_${lookup_name} ADD CONSTRAINT chk_statefp CHECK (statefp = ''${state_fips}'');"