# HG changeset patch # User Sascha L. Teichmann # Date 1544189766 -3600 # Node ID 8fc1a2298acba7c178ad77da1d4c3f7eb52ac0c9 # Parent 44e0943302724e544b08331682c466378199a6fe Pseudo fixed unstaging of bottlenecks. diff -r 44e094330272 -r 8fc1a2298acb pkg/imports/bn.go --- 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.