From: Sarah Hoffmann <lonvia@denofr.de>
Date: Fri, 25 Aug 2023 12:20:27 +0000 (+0200)
Subject: be more strict about removal from place_to_be_deleted
X-Git-Tag: v4.3.0~14^2
X-Git-Url: https://git.openstreetmap.org/nominatim.git/commitdiff_plain/c5f5ab5363a9d466af334a7019604fadae805b78

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.
---

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