From 8eb39d6a6f3519f7cfc421cfdd7ff26974ef73f1 Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Wed, 29 Aug 2012 11:33:33 +0100 Subject: [PATCH] limit reindexing to buildings / addresses --- sql/functions.sql | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) 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; -- 2.39.5