From: Brian Quinion <openstreetmap@brian.quinion.co.uk>
Date: Wed, 29 Aug 2012 10:33:33 +0000 (+0100)
Subject: limit reindexing to buildings / addresses
X-Git-Tag: v2.0.0~26
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/8eb39d6a6f3519f7cfc421cfdd7ff26974ef73f1

limit reindexing to buildings / addresses
---

diff --git a/sql/functions.sql b/sql/functions.sql
index 398c2ee6..d5a1506e 100644
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1271,8 +1271,7 @@ BEGIN
       DELETE FROM place_boundingbox where place_id = NEW.place_id;
       result := deleteRoad(NEW.partition, NEW.place_id);
       result := deleteLocationArea(NEW.partition, NEW.place_id);
-      UPDATE placex set parent_place_id = null, indexed_status = 2 where parent_place_id = NEW.place_id and indexed_status = 0;
-      UPDATE placex set parent_place_id = null where parent_place_id = NEW.place_id;
+      UPDATE placex set indexed_status = 2 where parent_place_id = NEW.place_id and indexed_status = 0 and rank_search > 28;
       UPDATE placex set linked_place_id = null, indexed_status = 2 where linked_place_id = NEW.place_id and indexed_status = 0;
       UPDATE placex set linked_place_id = null where linked_place_id = NEW.place_id;
     END IF;