X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/553d8a828cdbb12fa4b544d511e78bf587838157..c70b6ccc6dd6f69e371dbf0bc9c40126a9a65e75:/sql/functions/placex_triggers.sql?ds=sidebyside 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,