From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 9 Feb 2014 07:31:07 +0000 (+0100)
Subject: remove landuses if the name is removed
X-Git-Tag: v2.2.0~5
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/0bdcaa09ec89ae7c3dee4aa092fbc7cad9880d17?ds=sidebyside

remove landuses if the name is removed

Fixes https://trac.openstreetmap.org/ticket/5104
---

diff --git a/sql/functions.sql b/sql/functions.sql
index d9a5d1be..62847e39 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2045,6 +2045,8 @@ BEGIN
 
   -- Just block these - lots and pointless
   IF NEW.class in ('landuse','natural') and NEW.name is null THEN
+    -- if the name tag was removed, older versions might still be lurking in the place table
+    DELETE FROM place where osm_type = NEW.osm_type and osm_id = NEW.osm_id and class = NEW.class and type = NEW.type;
     RETURN null;
   END IF;