annotate schema/updates/1311/01.improve_section_uniqueness.sql @ 4915:db134712519b fairway-marks-import

import overview remove fm prefix from import kind to circumvent layout problems
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 11 Feb 2020 16:13:57 +0100
parents fd9f171b87e4
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
4749
fd9f171b87e4 Generally disallow the same section name for different countries
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
1 ALTER TABLE waterway.sections
fd9f171b87e4 Generally disallow the same section name for different countries
Tom Gottfried <tom@intevation.de>
parents:
diff changeset
2 ADD EXCLUDE USING GiST (name WITH =, country WITH <>)