X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/fc19ebb2188a6e73faad07286518d83c041c9207..0a14142156a5c62d574e9f3172716ba19ea9d122:/sql/functions/placex_triggers.sql diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql index d74ac1c9..b84a2d6d 100644 --- a/sql/functions/placex_triggers.sql +++ b/sql/functions/placex_triggers.sql @@ -661,7 +661,7 @@ BEGIN UPDATE placex SET linked_place_id = NEW.place_id WHERE place_id = linked_node_id; IF NOT %REVERSE-ONLY% THEN DELETE FROM search_name WHERE place_id = linked_node_id; - END IF; + END IF; END LOOP; END IF; END LOOP; @@ -811,6 +811,7 @@ BEGIN IF NOT %REVERSE-ONLY% THEN DELETE FROM search_name WHERE place_id = location.place_id; END IF; + PERFORM deleteLocationArea(NEW.partition, location.place_id, NEW.rank_search); SELECT wikipedia, importance FROM compute_importance(location.extratags, NEW.country_code,