Mercurial > gemma

changeset 1781:0a53c33bc7b2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed broken SQL statement (once again).
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 11 Jan 2019 16:49:55 +0100
parents 48791416bea5
children 30c76168e6d0
files pkg/imports/agm.go
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/agm.go	Fri Jan 11 16:48:14 2019 +0100
+++ b/pkg/imports/agm.go	Fri Jan 11 16:49:55 2019 +0100
@@ -75,7 +75,8 @@
 ),
 to_delete AS (
   SELECT o.id AS id
-  FROM waterway.gauge_measurements oJOIN waterway.gauge_measurements n
+  FROM waterway.gauge_measurements o
+  JOIN waterway.gauge_measurements n
     ON n.fk_gauge_id = o.fk_gauge_id AND n.measure_date = o.measure_date
     WHERE n.id     IN (SELECT key FROM staged)
 	  AND o.id NOT IN (SELECT key FROM staged)