From f9ef8f0635a3349d99419c70f1d11ee15c94c660 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Tue, 29 Oct 2024 03:52:38 +0100 Subject: Relax some UNIQUE constraint on the MRR layer's DiaryNR column. Apparently there are duplicates for dnr BS 22-28-2000 (bearbetningskoncessioner_beviljade) and BS 23-126-2007, BS 23-116-2005, BS 23-226-1930, BS 23-149-1960, BS 23-7-2000, and BS 23-105-2010 (markanvisningar_bk_beviljade). --- config.yml | 6 ++++-- schema.sql | 16 ---------------- 2 files changed, 4 insertions(+), 18 deletions(-) diff --git a/config.yml b/config.yml index db812c6..304eb99 100644 --- a/config.yml +++ b/config.yml @@ -3174,7 +3174,8 @@ layers: comment: När tillståndets giltighet slutar - name: DiaryNr type: String - unique: true + # XXX how come there is no UNIQUE constraint here? + #unique: true width: 16 - name: LastUpdated type: Date @@ -3221,7 +3222,8 @@ layers: comment: Beslutsdatum - name: DiaryNr type: String - unique: true + # XXX how come there is no UNIQUE constraint here? + #unique: true width: 16 - name: LastUpdated type: Date diff --git a/schema.sql b/schema.sql index b32bc00..307acac 100644 --- a/schema.sql +++ b/schema.sql @@ -3222,14 +3222,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_applied" ADD CONSTRAINT "mrr:bearbetningskoncessioner_applied_pkey" PRIMARY KEY (ogc_fid); --- --- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" - ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_DiaryNr_key" UNIQUE ("DiaryNr"); - - -- -- Name: mrr:bearbetningskoncessioner_approved mrr:bearbetningskoncessioner_approved_Name_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- @@ -3246,14 +3238,6 @@ ALTER TABLE ONLY postgis."mrr:bearbetningskoncessioner_approved" ADD CONSTRAINT "mrr:bearbetningskoncessioner_approved_pkey" PRIMARY KEY (ogc_fid); --- --- Name: mrr:markanvisningar mrr:markanvisningar_DiaryNr_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import --- - -ALTER TABLE ONLY postgis."mrr:markanvisningar" - ADD CONSTRAINT "mrr:markanvisningar_DiaryNr_key" UNIQUE ("DiaryNr"); - - -- -- Name: mrr:markanvisningar mrr:markanvisningar_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3