revert attempt to fix house number re-indexing on update, far too slow

diff --git a/sql/functions.sql b/sql/functions.sql
index d5a1506e6c3b846aba029271b5a7dd914137e493..20c8c2ab3f33b7784cf358ab9f5cf6376bc943d3 100644 (file)
--- a/sql/functions.sql
+++ b/sql/functions.sql
@@ -1271,8 +1271,6 @@ 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);
       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 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;
 
       UPDATE placex set linked_place_id = null where linked_place_id = NEW.place_id;
     END IF;