Mercurial > gemma

diff pkg/imports/fa.go @ 4461:7128741faeb9

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Changed fa data to accept "position" as strings, not a 2char "position_code"
author Sascha Wilde <wilde@intevation.de>
date Mon, 23 Sep 2019 12:59:48 +0200
parents c811d5da69bd
children 9b1e5a3ed3cc
line wrap: on
line diff
--- a/pkg/imports/fa.go	Mon Sep 23 11:34:06 2019 +0200
+++ b/pkg/imports/fa.go	Mon Sep 23 12:59:48 2019 +0200
@@ -68,7 +68,7 @@
 
 	insertFASQL = `
 INSERT INTO waterway.fairway_availability (
-  position_code,
+  position,
   bottleneck_id,
   surdat,
   critical,
@@ -82,7 +82,7 @@
   $5,
   $6
 ) ON CONFLICT (bottleneck_id, surdat) DO UPDATE SET
-  position_code = EXCLUDED.position_code,
+  position = EXCLUDED.position,
   critical = EXCLUDED.critical,
   date_info = EXCLUDED.date_info,
   source_organization = EXCLUDED.source_organization