From ddf866c4c77256f62fdfd2996ccaf7a6cdcb3074 Mon Sep 17 00:00:00 2001 From: AntoJvlt Date: Sat, 12 Jun 2021 15:35:51 +0200 Subject: [PATCH] Always delete old placex entry for type=postcode when inserting a new one into the place table --- lib-sql/functions/place_triggers.sql | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) diff --git a/lib-sql/functions/place_triggers.sql b/lib-sql/functions/place_triggers.sql index 43bae856..dd0f1662 100644 --- a/lib-sql/functions/place_triggers.sql +++ b/lib-sql/functions/place_triggers.sql @@ -95,10 +95,8 @@ BEGIN -- Pure postcodes are never queried from placex so we don't add them. -- location_postcodes is filled from the place table directly. IF NEW.class = 'place' AND NEW.type = 'postcode' THEN - -- Remove old placex entry if the type changed to postcode. - IF existingplacex.type IS NOT NULL AND existingplacex.type != 'postcode' THEN - DELETE FROM placex where osm_type = NEW.osm_type and osm_id = NEW.osm_id; - END IF; + -- Remove old placex entry. + DELETE FROM placex where osm_type = NEW.osm_type and osm_id = NEW.osm_id; RETURN NEW; END IF; -- 2.39.5