From: Sarah Hoffmann <lonvia@denofr.de>
Date: Tue, 14 May 2013 20:55:20 +0000 (+0200)
Subject: update admin_level when modifying place
X-Git-Tag: v2.2.0~71
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/7ca4259866625413a2f2a9112bc3b756a3fa3299

update admin_level when modifying place
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 99272d89..5179195b 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2230,6 +2230,7 @@ BEGIN
       postcode = NEW.postcode,
       country_code = NEW.country_code,
       extratags = NEW.extratags,
+      admin_level = NEW.admin_level,
       geometry = NEW.geometry
       where osm_type = NEW.osm_type and osm_id = NEW.osm_id and class = NEW.class and type = NEW.type;
 
@@ -2243,6 +2244,7 @@ BEGIN
       country_code = NEW.country_code,
       parent_place_id = null,
       extratags = NEW.extratags,
+      admin_level = NEW.admin_level,
       indexed_status = 2,    
       geometry = NEW.geometry
       where place_id = existingplacex.place_id;