X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/f822b04dbe7caf9794b4f206fd8b75ad0ceafd15..33f7bba69858405517c68a4aaf609ce69e00e277:/sql/functions.sql

diff --git a/sql/functions.sql b/sql/functions.sql
index 6c9e092e..839d086c 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -2068,6 +2068,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;
 
