From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 4 Apr 2020 16:26:27 +0000 (+0200)
Subject: avoid deletes on search_name in reverse-only mode
X-Git-Tag: v3.5.0~53
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/81c7f618fb52b0f8524e1953d02660159e7c2fde

avoid deletes on search_name in reverse-only mode
---

diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql
index 5c04ad06..c04aef28 100644
--- a/sql/functions/placex_triggers.sql
+++ b/sql/functions/placex_triggers.sql
@@ -715,7 +715,9 @@ BEGIN
                   and ( relation_members[i+1] != 'side_stream' or NEW.name->'name' = name->'name')
                 LOOP
                   UPDATE placex SET linked_place_id = NEW.place_id WHERE place_id = linked_node_id;
-                  DELETE FROM search_name WHERE place_id = linked_node_id;
+                  IF NOT %REVERSE-ONLY% THEN
+                    DELETE FROM search_name WHERE place_id = linked_node_id;
+		  END IF;
                 END LOOP;
               END IF;
           END LOOP;
@@ -858,7 +860,9 @@ BEGIN
     UPDATE placex set linked_place_id = NEW.place_id
       WHERE place_id = location.place_id;
     -- ensure that those places are not found anymore
-    DELETE FROM search_name WHERE place_id = location.place_id;
+    IF NOT %REVERSE-ONLY% THEN
+      DELETE FROM search_name WHERE place_id = location.place_id;
+    END IF;
 
     SELECT wikipedia, importance
       FROM compute_importance(location.extratags, NEW.country_code,