Mercurial > gemma
changeset 1502:0abcc82ef976
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 (