X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/a437f5d18a48d3f982e965ef81c93f71a73e53e0..61e3a053723a6a1131e234aa8ad1a37f18bbec56:/sql/functions/place_triggers.sql?ds=inline diff --git a/sql/functions/place_triggers.sql b/sql/functions/place_triggers.sql index 71f918c5..b7b51150 100644 --- a/sql/functions/place_triggers.sql +++ b/sql/functions/place_triggers.sql @@ -262,7 +262,7 @@ BEGIN -- deleting large polygons can have a massive effect on the system - require manual intervention to let them through IF st_area(OLD.geometry) > 2 and st_isvalid(OLD.geometry) THEN - SELECT bool_or(not (rank_address = 0 or rank_address > 26)) as ranked FROM placex WHERE osm_type = OLD.osm_type and osm_id = OLD.osm_id and class = OLD.class and type = OLD.type INTO has_rank; + SELECT bool_or(not (rank_address = 0 or rank_address > 25)) as ranked FROM placex WHERE osm_type = OLD.osm_type and osm_id = OLD.osm_id and class = OLD.class and type = OLD.type INTO has_rank; IF has_rank THEN insert into import_polygon_delete (osm_type, osm_id, class, type) values (OLD.osm_type,OLD.osm_id,OLD.class,OLD.type); RETURN NULL;