Mercurial > gemma
annotate schema/updates/1311/01.improve_section_uniqueness.sql @ 5115:bb5459faadb7 queued-stage-done
Dont leave old jobs behind if retrying remove jobs.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 25 Mar 2020 18:02:46 +0100 |
parents | fd9f171b87e4 |
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 <>) |