make sure that linked places are within a boundary

This is a regression from previous code refactoring.

Fixes #1684.

diff --git a/sql/functions/placex_triggers.sql b/sql/functions/placex_triggers.sql
index d6ae88384f462c41bf58e2d6052b70db62b4cfa8..d247651ed490779cdb3b13a8534c483d884e618b 100644 (file)
--- a/sql/functions/placex_triggers.sql
+++ b/sql/functions/placex_triggers.sql
@@ -226,7 +226,7 @@ BEGIN
         AND placex.rank_address = bnd.rank_address
         AND placex.osm_type = 'N'
         AND placex.rank_search < 26 -- needed to select the right index
         AND placex.rank_address = bnd.rank_address
         AND placex.osm_type = 'N'
         AND placex.rank_search < 26 -- needed to select the right index

-        AND st_covers(geometry, placex.geometry)
+        AND _st_covers(bnd.geometry, placex.geometry)

     LOOP
       --DEBUG: RAISE WARNING 'Found matching place node %', linkedPlacex.osm_id;
       RETURN linked_placex;
     LOOP
       --DEBUG: RAISE WARNING 'Found matching place node %', linkedPlacex.osm_id;
       RETURN linked_placex;