From afe30880b413688ea8660c870d5694ff97b24937 Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Fri, 31 Aug 2012 12:21:07 +0100 Subject: [PATCH] revert attempt to fix house number re-indexing on update, far too slow --- sql/functions.sql | 2 -- 1 file changed, 2 deletions(-) diff --git a/sql/functions.sql b/sql/functions.sql index d5a1506e..20c8c2ab 100644 --- 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); - 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.45.2