From ce3fda6ab5a5ad8b3f70c51a02dd52817a05ade1 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Sat, 10 Aug 2013 06:26:59 +0000 Subject: [PATCH] #2414 extension not installing census tables git-svn-id: http://svn.osgeo.org/postgis/trunk@11761 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2011/census_loader.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/extras/tiger_geocoder/tiger_2011/census_loader.sql b/extras/tiger_geocoder/tiger_2011/census_loader.sql index d963a9a86..20ee8efdf 100644 --- a/extras/tiger_geocoder/tiger_2011/census_loader.sql +++ b/extras/tiger_geocoder/tiger_2011/census_loader.sql @@ -183,3 +183,6 @@ VALUES(12, 'bg', 'bg', true,false, true,false, 'c', ${psql} -c "ALTER TABLE ${data_schema}.${state_abbrev}_${lookup_name} ADD CONSTRAINT chk_statefp CHECK (statefp = ''${state_fips}'');" ${psql} -c "CREATE INDEX ${data_schema}_${state_abbrev}_${lookup_name}_the_geom_gist ON ${data_schema}.${state_abbrev}_${lookup_name} USING gist(the_geom);" ${psql} -c "vacuum analyze ${data_schema}.${state_abbrev}_${lookup_name};"', ARRAY['gid']); + + +SELECT create_census_base_tables(); -- 2.40.0