]> git.openstreetmap.org Git - nominatim.git/commitdiff
avoid deletes on search_name in reverse-only mode
authorSarah Hoffmann <lonvia@denofr.de>
Sat, 4 Apr 2020 16:26:27 +0000 (18:26 +0200)
committerSarah Hoffmann <lonvia@denofr.de>
Sat, 4 Apr 2020 16:26:27 +0000 (18:26 +0200)
sql/functions/placex_triggers.sql

index 5c04ad065a9c58211e0bbb3912ac457f4adc76fa..c04aef286855ee12dd078d18e83b18daf5e36931 100644 (file)
@@ -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,