From c5f5ab5363a9d466af334a7019604fadae805b78 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Fri, 25 Aug 2023 14:20:27 +0200 Subject: [PATCH] be more strict about removal from place_to_be_deleted If the type of a place is changed and then the same insert issued again, the old data will effectively remain in the table. Fixed #3168. --- lib-sql/functions/place_triggers.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib-sql/functions/place_triggers.sql b/lib-sql/functions/place_triggers.sql index 6a52021b..3def6596 100644 --- a/lib-sql/functions/place_triggers.sql +++ b/lib-sql/functions/place_triggers.sql @@ -37,7 +37,7 @@ BEGIN -- Remove the place from the list of places to be deleted DELETE FROM place_to_be_deleted pdel WHERE pdel.osm_type = NEW.osm_type and pdel.osm_id = NEW.osm_id - and pdel.class = NEW.class; + and pdel.class = NEW.class and pdel.type = NEW.type; -- Have we already done this place? SELECT * INTO existing -- 2.45.1