From 0bfdd558009942897ad6e18e907f62c1975b033d Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Wed, 25 Jan 2017 23:46:00 +0000 Subject: [PATCH] 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 git-svn-id: http://svn.osgeo.org/postgis/trunk@15294 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_loader_2016.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/tiger_loader_2016.sql b/extras/tiger_geocoder/tiger_loader_2016.sql index 08bf8c4e6..7418e3aa4 100644 --- a/extras/tiger_geocoder/tiger_loader_2016.sql +++ b/extras/tiger_geocoder/tiger_loader_2016.sql @@ -263,7 +263,7 @@ VALUES(10, 'tract', 'tract', true, false, true,false, 'c', ${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}'');" -- 2.50.1