Mercurial > gemma
diff cmd/octree2contour/store.go @ 736:34ea9d5df653
Fixed problem with unique constraint for countour lines.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Mon, 24 Sep 2018 11:24:42 +0200 |
| parents | 83a9f04f1759 |
| children | fb9faf2c4f60 |
line wrap: on
line diff
--- a/cmd/octree2contour/store.go Mon Sep 24 10:58:34 2018 +0200 +++ b/cmd/octree2contour/store.go Mon Sep 24 11:24:42 2018 +0200 @@ -21,8 +21,9 @@ ` insertSQL = ` INSERT INTO waterway.sounding_results_contour_lines + (sounding_result_id, height, lines) SELECT - sounding_result_id, + id, $1, ST_Transform(ST_SetSRID(ST_GeomFromWKB($2), $3), 4326)::geography FROM waterway.sounding_results