# HG changeset patch
# User Sascha Wilde <wilde@intevation.de>
# Date 1563982536 -7200
# Node ID 8ab4c6dc3d6c1d0037f7defe60854d5123264b44
# Parent  0b65915757c87e0eeb59c9465f72f0c360123e15
Adapted loadLDCReferenceValue to new historization model.

diff -r 0b65915757c8 -r 8ab4c6dc3d6c pkg/controllers/bottlenecks.go
--- a/pkg/controllers/bottlenecks.go	Wed Jul 24 17:30:22 2019 +0200
+++ b/pkg/controllers/bottlenecks.go	Wed Jul 24 17:35:36 2019 +0200
@@ -83,7 +83,7 @@
 FROM waterway.gauges_reference_water_levels grwl
   JOIN waterway.bottlenecks bns
     ON grwl.location = bns.gauge_location
-      AND grwl.validity = bns.gauge_validity
+      AND grwl.validity @> current_timestamp
 WHERE bns.validity @> current_timestamp
   AND bns.objnam = $1
   AND grwl.depth_reference like 'LDC%'