X-Git-Url: https://git.openstreetmap.org./nominatim.git/blobdiff_plain/36cf0eb922d4c03e73a3a3a5505e46d5cee061b9..dc2c384208dfbd2d1e3018eb2a0f9f1ee12bea6d:/lib-sql/functions/place_triggers.sql diff --git a/lib-sql/functions/place_triggers.sql b/lib-sql/functions/place_triggers.sql index ca6ba690..489ecb35 100644 --- a/lib-sql/functions/place_triggers.sql +++ b/lib-sql/functions/place_triggers.sql @@ -194,7 +194,7 @@ BEGIN -- Mark any existing place for delete in the placex table UPDATE placex SET indexed_status = 100 WHERE placex.osm_type = NEW.osm_type and placex.osm_id = NEW.osm_id - and placex.class = 'boundary' and placex.type = 'administrative'; + and placex.class = NEW.class and placex.type = NEW.type; END IF; -- Process it as a new insertion