From: Brian Quinion <brian.quinion@mapquest.com>
Date: Thu, 26 Jun 2014 16:12:39 +0000 (+0100)
Subject: update tiger import for changes to functions.sql
X-Git-Tag: v2.3.0~24
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/7c54c81b77c21bbd9551920c0f0c444e7d3d3d6d

update tiger import for changes to functions.sql
---

diff --git a/sql/tiger_import_start.sql b/sql/tiger_import_start.sql
index d9def2b4..a6f417f2 100644
--- a/sql/tiger_import_start.sql
+++ b/sql/tiger_import_start.sql
@@ -53,12 +53,12 @@ BEGIN
   END IF;
 
   place_centroid := ST_Centroid(linegeo);
-  out_partition := get_partition(place_centroid, 'us');
+  out_partition := get_partition('us');
   out_parent_place_id := null;
 
   address_street_word_id := get_name_id(make_standard_name(in_street));
   IF address_street_word_id IS NOT NULL THEN
-    FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, address_street_word_id) LOOP
+    FOR location IN SELECT * from getNearestNamedRoadFeature(out_partition, place_centroid, ARRAY[address_street_word_id]) LOOP
       out_parent_place_id := location.place_id;
     END LOOP;
   END IF;