Mercurial > gemma

changeset 1684:b20b68adfe80

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Waterway axis: Removed unique geohash index. We need to discuss if this index kind is the right way to prevent duplicates.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 27 Dec 2018 23:23:36 +0100
parents 509e8728e846
children 8f5a5c86f2a9
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Dec 27 22:49:35 2018 +0100
+++ b/schema/gemma.sql	Thu Dec 27 23:23:36 2018 +0100
@@ -302,7 +302,8 @@
         objnam varchar NOT NULL,
         nobjnam varchar
     )
-    CREATE UNIQUE INDEX ON waterway_axis ((ST_GeoHash(wtwaxs, 23)))
+    -- TODO: @tom: Why did you choose this index kind?
+    -- CREATE UNIQUE INDEX ON waterway_axis ((ST_GeoHash(wtwaxs, 23)))
 
     -- This table allows linkage between 1D ISRS location codes and 2D space
     -- e.g. for cutting bottleneck area out of waterway area based on virtual