From b1bd98f07064ed0bf4ed99105ab6038434d48041 Mon Sep 17 00:00:00 2001 From: Brian Quinion Date: Tue, 28 Aug 2012 19:05:01 +0100 Subject: [PATCH] mark placex as needed re-indexin based on parent_place_id too --- sql/functions.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/functions.sql b/sql/functions.sql index 13c682ae..398c2ee6 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1271,6 +1271,8 @@ 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 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