From 2643225b72fe2d32ced5191511a059e88badac79 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sun, 6 Jul 2014 23:15:53 +0200 Subject: [PATCH] fix member lookup in empty waterway relations --- sql/functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/functions.sql b/sql/functions.sql index dbb624f8..5c4cea05 100644 --- a/sql/functions.sql +++ b/sql/functions.sql @@ -1372,7 +1372,7 @@ BEGIN -- waterway ways are linked when they are part of a relation and have the same class/type IF NEW.osm_type = 'R' and NEW.class = 'waterway' THEN - FOR relation IN select * from planet_osm_rels r where r.id = NEW.osm_id + FOR relation IN select * from planet_osm_rels r where r.id = NEW.osm_id and r.parts != array[]::bigint[] LOOP FOR i IN 1..array_upper(relation.members, 1) BY 2 LOOP IF relation.members[i+1] in ('', 'main_stream') AND substring(relation.members[i],1,1) = 'w' THEN -- 2.39.5