From 96530eb76be377251c88a565ef3eda395edf1136 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 11 Aug 2012 19:49:05 +0000 Subject: [PATCH] #1838 tabblock not loading git-svn-id: http://svn.osgeo.org/postgis/trunk@10177 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2011/tiger_loader_2011.sql | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) diff --git a/extras/tiger_geocoder/tiger_2011/tiger_loader_2011.sql b/extras/tiger_geocoder/tiger_2011/tiger_loader_2011.sql index 07ca6319f..e033e158d 100644 --- a/extras/tiger_geocoder/tiger_2011/tiger_loader_2011.sql +++ b/extras/tiger_geocoder/tiger_2011/tiger_loader_2011.sql @@ -364,9 +364,10 @@ LANGUAGE 'plpgsql' VOLATILE; CREATE OR REPLACE FUNCTION loader_load_staged_data(param_staging_table text, param_target_table text) RETURNS integer AS $$ +-- exclude this set list of columns if no exclusion list is specified SELECT loader_load_staged_data($1, $2,(SELECT COALESCE(columns_exclude,ARRAY['gid', 'geoid','cpi','suffix1ce', 'statefp00', 'statefp10', 'countyfp00','countyfp10' - ,'tractce00','tractce10', 'blkgrpce00', 'blkgrpce10', 'blockce00', 'blockce10', - 'cousubfp00', 'submcdfp00', 'conctyfp00', 'placefp00', 'aiannhfp00', 'aiannhce00', + ,'tractce00','tractce10', 'blkgrpce00', 'blkgrpce10', 'blockce00', 'blockce10', 'suffix1ce' + , 'cousubfp00', 'submcdfp00', 'conctyfp00', 'placefp00', 'aiannhfp00', 'aiannhce00', 'comptyp00', 'trsubfp00', 'trsubce00', 'anrcfp00', 'elsdlea00', 'scsdlea00', 'unsdlea00', 'uace00', 'cd108fp', 'sldust00', 'sldlst00', 'vtdst00', 'zcta5ce00', 'tazce00', 'ugace00', 'puma5ce00','vtdst10','tazce10','uace10','puma5ce10','tazce', 'uace', 'vtdst', 'zcta5ce', 'zcta5ce10', 'puma5ce']) FROM loader_lookuptables WHERE $2 LIKE '%' || lookup_name)) -- 2.40.0