diff pkg/imports/bn.go @ 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 24445a618513
children cf0ca4a9812a
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.