From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 8 Feb 2014 18:23:06 +0000 (+0100)
Subject: restrict admin_level change detection to boundary=administrative
X-Git-Tag: v2.2.0~6
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/8c2765a000a98c37e3a1e6a710a0bdf7beef480f

restrict admin_level change detection to boundary=administrative
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 49a6e972..d9a5d1be 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2092,7 +2092,7 @@ BEGIN
 
   -- To paraphrase, if there isn't an existing item, OR if the admin level has changed
   IF existingplacex.osm_type IS NULL OR
-     coalesce(existingplacex.admin_level, 15) != coalesce(NEW.admin_level, 15)
+    (coalesce(existingplacex.admin_level, 15) != coalesce(NEW.admin_level, 15) AND existingplacex.class = 'boundary' AND existingplacex.type = 'administrative')
   THEN
 
     IF existingplacex.osm_type IS NOT NULL THEN