Mercurial > gemma
annotate schema/updates/1311/01.improve_section_uniqueness.sql @ 4749:fd9f171b87e4
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 |
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 <>) |