From 5d31f04f3a0073f9b1b5d61a318100fccf6d2d84 Mon Sep 17 00:00:00 2001 From: Stephen Frost Date: Sun, 8 Jul 2007 21:56:47 +0000 Subject: [PATCH] - City names are 90 characters (this matters more than you might think because it affects the types returned from the various calls and if they don't match subsequent geocode() queries in the same session may complain about the planned record type not matching across calls) git-svn-id: http://svn.osgeo.org/postgis/trunk@2649 b70326c6-7e19-0410-871a-916f4a2858ee --- extras/tiger_geocoder/tables/lookup_tables.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/extras/tiger_geocoder/tables/lookup_tables.sql b/extras/tiger_geocoder/tables/lookup_tables.sql index 2fafa8c30..e4840a67d 100644 --- a/extras/tiger_geocoder/tables/lookup_tables.sql +++ b/extras/tiger_geocoder/tables/lookup_tables.sql @@ -845,7 +845,7 @@ CREATE TABLE zip_lookup_base ( zip INTEGER, state VARCHAR(40), county VARCHAR(90), - city VARCHAR(100), + city VARCHAR(90), PRIMARY KEY (zip) ); -- 2.49.0