Mercurial > gemma

changeset 995:e03fab882b47

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use distance_marks_virtual table for search. This is a (hot?) fix as the distance_marks table is now empty for some reasons...
author Sascha Wilde <wilde@intevation.de>
date Mon, 22 Oct 2018 13:12:28 +0200
parents d9cc1e906469
children 839526f44f0f 26ca04caa330
files pkg/controllers/search.go
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/search.go	Mon Oct 22 13:09:26 2018 +0200
+++ b/pkg/controllers/search.go	Mon Oct 22 13:12:28 2018 +0200
@@ -14,7 +14,7 @@
 	searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]')
 FROM (SELECT (location_code).hectometre || ' rhm' AS name,
              ST_AsGeoJSON(geom)::json AS geom
-      FROM waterway.distance_marks
+      FROM waterway.distance_marks_virtual
       WHERE (location_code).hectometre = $1) r`
 	searchBottleneckSQL = `SELECT COALESCE(json_agg(r),'[]')
 FROM (SELECT objnam AS name,