# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1537781082 -7200
# Node ID 34ea9d5df653eb60455bed9a835f1cd7a8083108
# Parent  83a9f04f17598491bbf2e178c4a280bb61f58fed
Fixed problem with unique constraint for countour lines.

diff -r 83a9f04f1759 -r 34ea9d5df653 cmd/octree2contour/store.go
--- 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
diff -r 83a9f04f1759 -r 34ea9d5df653 schema/gemma.sql
--- a/schema/gemma.sql	Mon Sep 24 10:58:34 2018 +0200
+++ b/schema/gemma.sql	Mon Sep 24 11:24:42 2018 +0200
@@ -413,7 +413,7 @@
     )
 
     CREATE TABLE sounding_results_contour_lines (
-        sounding_result_id int NOT NULL UNIQUE REFERENCES sounding_results,
+        sounding_result_id int NOT NULL REFERENCES sounding_results,
         height numeric NOT NULL,
         lines geography(multilinestringz, 4326) NOT NULL,
         UNIQUE (sounding_result_id, height)