diff schema/gemma.sql @ 5425:345515bc4548 marking-single-beam

Make GeoServer layer sounding_results_marking_points_geoserver working.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 09 Jul 2021 22:03:44 +0200
parents ad8e3fffb868
children 8797274e2739
line wrap: on
line diff
--- a/schema/gemma.sql	Fri Jul 09 01:35:04 2021 +0200
+++ b/schema/gemma.sql	Fri Jul 09 22:03:44 2021 +0200
@@ -833,6 +833,9 @@
         sounding_result_id int NOT NULL REFERENCES sounding_results
           ON DELETE CASCADE,
         height numeric NOT NULL,
+        -- XXX: GeoServer does not like geography(MULTIPOINTZ)
+        --      We need to track this down. Maybe with
+        --      GeoServer upstream.
         points geography(MULTIPOINTZ, 4326) NOT NULL,
         PRIMARY KEY (sounding_result_id, height)
     )