diff options
author | Guilhem Moulin <guilhem@fripost.org> | 2024-06-12 02:01:47 +0200 |
---|---|---|
committer | Guilhem Moulin <guilhem@fripost.org> | 2024-06-12 02:01:47 +0200 |
commit | 3bd492be08a97c16c813bc57773028def5c69e23 (patch) | |
tree | a0a1d10f7da26a08baa1323cb1d0f6777b061871 /schema.sql | |
parent | 42cfe748e23bad6fc51b14a3e5896a77fdb5c1d5 (diff) |
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.
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 8 |
1 files changed, 8 insertions, 0 deletions
@@ -367,6 +367,14 @@ ALTER TABLE ONLY postgis."sks:AvverkAnm" -- +-- 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 -- |