annotate schema/updates/1311/01.improve_section_uniqueness.sql @ 5099:3cd736acbad3 queued-stage-done

First version of a reviewed job. I bet it does not work.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 24 Mar 2020 15:46:37 +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 <>)