Mercurial > gemma

changeset 4092:30a567b1cc2e historization_ng

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Re-added uniq constraint after waterway.fairway_availability update.
author Sascha Wilde <wilde@intevation.de>
date Thu, 25 Jul 2019 17:21:03 +0200
parents c0642c1c0ff8
children c1c6a375305f
files schema/updates/1100/02.remove_bottleneck_validity_refs.sql
diffstat 1 files changed, 5 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/schema/updates/1100/02.remove_bottleneck_validity_refs.sql	Thu Jul 25 17:06:19 2019 +0200
+++ b/schema/updates/1100/02.remove_bottleneck_validity_refs.sql	Thu Jul 25 17:21:03 2019 +0200
@@ -168,6 +168,8 @@
       SET bottleneck_id = b.bottleneck_id
       FROM waterway.bottlenecks b
       WHERE b.id = fwa.old_bnid;
+  ALTER TABLE waterway.fairway_availability
+      ALTER COLUMN bottleneck_id SET NOT NULL;
 
   -- Set constraint trigger to make sure a matching BN exists:
   --
@@ -236,6 +238,9 @@
   -- Finally dropt the old column
   ALTER TABLE waterway.fairway_availability
       DROP COLUMN old_bnid;
+  ALTER TABLE waterway.fairway_availability
+      ADD CONSTRAINT fairway_availability_bottleneck_id_surdat_key
+      UNIQUE (bottleneck_id, surdat);
 \else
   \qecho 'NOTICE: bottleneck_id column in fairway_availability alread migrated.'
 \endif