Mercurial > gemma

diff pkg/imports/sr.go @ 1501:048d1891e004

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 5df748916fcf
children 0abcc82ef976
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 (