changeset 1501:048d1891e004

Fixed problem with accepting sounding result imports and moving them out of the staging area.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 05 Dec 2018 11:00:53 +0100
parents 811497a8092f
children 0abcc82ef976
files pkg/imports/sr.go
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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 (