Mercurial > gemma
diff pkg/imports/sr.go @ 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 | 5874cedd7f91 |
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 (