Mercurial > gemma

annotate schema/updates/1311/01.improve_section_uniqueness.sql @ 4749:fd9f171b87e4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Generally disallow the same section name for different countries This avoids the situation that a waterway admin is informed about the duplicate name only on trying to accept the import of a new section. Such an import will now end up failed.
author Tom Gottfried <tom@intevation.de>
date Fri, 18 Oct 2019 15:45:48 +0200
parents
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 <>)