changeset 5246:6cbfa3c3803d new-fwa

stretches und sections are in different schemata.
author Sascha L. Teichmann <teichmann@intevation.de>
date Tue, 12 May 2020 22:13:37 +0200
parents 9dd1ae697f93
children d89f5d75223e
files pkg/controllers/fwa.go
diffstat 1 files changed, 3 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/fwa.go	Tue May 12 22:07:56 2020 +0200
+++ b/pkg/controllers/fwa.go	Tue May 12 22:13:37 2020 +0200
@@ -47,7 +47,7 @@
 SELECT
   distinct(b.bottleneck_id)
 FROM
-  users.%s s, waterway.bottlenecks b
+  %s s, waterway.bottlenecks b
 WHERE
   ST_Intersects(b.area, s.area)
   AND s.name = $1
@@ -672,7 +672,7 @@
 	return loadSymbolBottlenecksFromTo(
 		ctx,
 		conn,
-		"stretches", name,
+		"users.stretches", name,
 		from, to)
 }
 
@@ -685,7 +685,7 @@
 	return loadSymbolBottlenecksFromTo(
 		ctx,
 		conn,
-		"sections", name,
+		"waterway.sections", name,
 		from, to)
 }