From 3bd492be08a97c16c813bc57773028def5c69e23 Mon Sep 17 00:00:00 2001 From: Guilhem Moulin Date: Wed, 12 Jun 2024 02:01:47 +0200 Subject: sks:UtfordAvverk: Add UNIQUE constraint on OBJECTID. Not sure why I thought there was duplicates but I must have done something wrong as there are none in the 667034+223463+214082+ 72656 = 1177234 features found after removing the spatial filter. --- schema.sql | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'schema.sql') diff --git a/schema.sql b/schema.sql index 3cb7d18..25cf25b 100644 --- a/schema.sql +++ b/schema.sql @@ -366,6 +366,14 @@ ALTER TABLE ONLY postgis."sks:AvverkAnm" ADD CONSTRAINT "sks:AvverkAnm_pkey" PRIMARY KEY (ogc_fid); +-- +-- Name: sks:UtfordAvverk sks:UtfordAvverk_OBJECTID_key; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import +-- + +ALTER TABLE ONLY postgis."sks:UtfordAvverk" + ADD CONSTRAINT "sks:UtfordAvverk_OBJECTID_key" UNIQUE ("OBJECTID"); + + -- -- Name: sks:UtfordAvverk sks:UtfordAvverk_pkey; Type: CONSTRAINT; Schema: postgis; Owner: webmap_import -- -- cgit v1.2.3