From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sun, 10 May 2020 11:59:47 +0000 (+0200)
Subject: remove linked places also from the location_area_large tables
X-Git-Tag: v3.5.0~18^2
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/0a14142156a5c62d574e9f3172716ba19ea9d122

remove linked places also from the location_area_large tables

We don't want linked places to show up in addresses either,
so remove them from the address lookup table.
---

diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql
index d74ac1c9..b84a2d6d 100644
--- a/sql/functions/placex_triggers.sql
+++ b/sql/functions/placex_triggers.sql
@@ -661,7 +661,7 @@ BEGIN
                   UPDATE placex SET linked_place_id = NEW.place_id WHERE place_id = linked_node_id;
                   IF NOT %REVERSE-ONLY% THEN
                     DELETE FROM search_name WHERE place_id = linked_node_id;
-		  END IF;
+                  END IF;
                 END LOOP;
               END IF;
           END LOOP;
@@ -811,6 +811,7 @@ BEGIN
     IF NOT %REVERSE-ONLY% THEN
       DELETE FROM search_name WHERE place_id = location.place_id;
     END IF;
+    PERFORM deleteLocationArea(NEW.partition, location.place_id, NEW.rank_search);
 
     SELECT wikipedia, importance
       FROM compute_importance(location.extratags, NEW.country_code,