diff schema/gemma.sql @ 4358:a7196b55c064

Remove VIEW columns ignored by GeoServer Removed columns were ignored with a warning on layer creation.
author Tom Gottfried <tom@intevation.de>
date Mon, 09 Sep 2019 16:13:26 +0200
parents 27ed6f709195
children 5e38667f740c 970e90d3d5eb
line wrap: on
line diff
--- a/schema/gemma.sql	Mon Sep 09 16:12:43 2019 +0200
+++ b/schema/gemma.sql	Mon Sep 09 16:13:26 2019 +0200
@@ -777,8 +777,8 @@
 
 -- Configure primary keys for geoserver views
 INSERT INTO waterway.gt_pk_metadata VALUES
-  ('waterway', 'gauges_geoserver', 'location'),
-  ('waterway', 'distance_marks_geoserver', 'location_code'),
+  ('waterway', 'gauges_geoserver', 'isrs_code'),
+  ('waterway', 'distance_marks_geoserver', 'location'),
   ('waterway', 'distance_marks_ashore_geoserver', 'id'),
   ('waterway', 'bottlenecks_geoserver', 'id'),
   ('waterway', 'stretches_geoserver', 'id'),