Fix bug in index.c and remove column admin_level from location_property_osmline.

[nominatim.git] / sql / functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index 9b095ce7b9636067c2df0c1b249d1a114a572845..a5200973af3f1a7d49e597eba606f7298c32d18c 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -734,9 +734,9 @@ BEGIN
                              and place_id != prevnode.place_id and class = 'place'
                              and type = 'house';
         insert into location_property_osmline
-          values (sectiongeo, nextval('seq_place'), partition, wayid, NULL, startnumber, endnumber, interpolationtype, prevnode.admin_level,
-           street, coalesce(prevnode.postcode, defpostalcode),
-           calculated_country_code, geometry_sector, 2, now());
+          values (sectiongeo, nextval('seq_place'), partition, wayid, NULL, startnumber, endnumber, 
+          interpolationtype, street, coalesce(prevnode.postcode, defpostalcode),
+          calculated_country_code, geometry_sector, 2, now());
       END IF;
 
       -- early break if we are out of line string,