changeset 1533:8fc1a2298acb

Pseudo fixed unstaging of bottlenecks.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 07 Dec 2018 14:36:06 +0100
parents 44e094330272
children 165f31b71042
files pkg/imports/bn.go
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/bn.go	Fri Dec 07 13:34:44 2018 +0100
+++ b/pkg/imports/bn.go	Fri Dec 07 14:36:06 2018 +0100
@@ -51,12 +51,13 @@
 }
 
 const (
+	// TODO: waterway.bottlenecks needs an integer id column.
 	bnStageDoneSQL = `
-UPDATE waterway.sounding_results SET staging_done = true
-WHERE id = (
+UPDATE waterway.bottlenecks SET staging_done = true
+WHERE id IN (
   SELECT key from waterway.track_imports
   WHERE import_id = $1 AND
-        relation = 'waterway.sounding_results'::regclass)`
+        relation = 'waterway.bottlenecks'::regclass)`
 )
 
 // StageDone moves the imported bottleneck out of the staging area.