# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1544004053 -3600
# Node ID 048d1891e004a2b2ceba47c3b8c2d76d0514606e
# Parent  811497a8092f5057088210cb0de66eeeec3835cc
Fixed problem with accepting sounding result imports and moving them out of the staging area.

diff -r 811497a8092f -r 048d1891e004 pkg/imports/sr.go
--- a/pkg/imports/sr.go	Wed Dec 05 10:17:13 2018 +0100
+++ b/pkg/imports/sr.go	Wed Dec 05 11:00:53 2018 +0100
@@ -102,7 +102,7 @@
 const (
 	srStageDoneSQL = `
 UPDATE waterway.sounding_results SET staging_done = true
-WHERE id = $1`
+WHERE id = (SELECT key from waterway.track_imports WHERE import_id = $1)`
 
 	insertPointsSQL = `
 INSERT INTO waterway.sounding_results (