From 7c0e4df9df6b8d15fef8689141177aff95c44aa5 Mon Sep 17 00:00:00 2001 From: Regina Obe Date: Tue, 28 Jun 2011 02:50:01 +0000 Subject: [PATCH] get rid of drop / recreate norm_addy. It's not necessary yet since we haven't changed it. git-svn-id: http://svn.osgeo.org/postgis/trunk@7508 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql b/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql index 47f9f62a7..fc03a30df 100644 --- a/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql +++ b/extras/tiger_geocoder/tiger_2010/upgrade_geocode.sql @@ -25,6 +25,7 @@ CREATE INDEX tiger_edges_the_geom_gist ON edges USING gist(the_geom); CREATE INDEX tiger_state_the_geom_gist ON faces USING gist(the_geom); DROP FUNCTION IF EXISTS reverse_geocode(geometry); /** changed to use default parameters **/ +-- TODO: Put in logic to update lookup tables as they change. street_type_lookup has changed since initial release -- CREATE TABLE zcta5 ( gid serial NOT NULL, @@ -50,7 +51,8 @@ BEGIN; -- Type used to pass around a normalized address between functions -- This is s bit dangerous since it could potentially drop peoples tables -- TODO: put in logic to check if any tables have norm_addy and don't drop if they do -DROP TYPE IF EXISTS norm_addy CASCADE; +-- Remarking this out for now since we aren't changing norm_addy anyway +/*DROP TYPE IF EXISTS norm_addy CASCADE; CREATE TYPE norm_addy AS ( address INTEGER, preDirAbbrev VARCHAR, @@ -61,7 +63,7 @@ CREATE TYPE norm_addy AS ( location VARCHAR, stateAbbrev VARCHAR, zip VARCHAR, - parsed BOOLEAN); + parsed BOOLEAN);*/ -- System/General helper functions \i utility/utmzone.sql -- 2.50.1