Mercurial > gemma

changeset 1502:0abcc82ef976

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Sounding results: Be a bit more precise when setting stageing_done. Doesn't really matter.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 05 Dec 2018 11:21:22 +0100
parents 048d1891e004
children b76b23b3df61
files pkg/imports/sr.go
diffstat 1 files changed, 4 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/sr.go	Wed Dec 05 11:00:53 2018 +0100
+++ b/pkg/imports/sr.go	Wed Dec 05 11:21:22 2018 +0100
@@ -102,7 +102,10 @@
 const (
 	srStageDoneSQL = `
 UPDATE waterway.sounding_results SET staging_done = true
-WHERE id = (SELECT key from waterway.track_imports WHERE import_id = $1)`
+WHERE id = (
+  SELECT key from waterway.track_imports
+  WHERE import_id = $1 AND
+        relation = 'waterway.sounding_results'::regclass)`
 
 	insertPointsSQL = `
 INSERT INTO waterway.sounding_results (