Mercurial > gemma
diff schema/tap_tests_data.sql @ 4404:b0c974fc7d34
Fixup rev. 5e38667f740c
Some countries are now hard-wired into the schema definition. Thus,
avoid the conflict when writing test data to the test database.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 16 Sep 2019 17:15:33 +0200 |
| parents | 5e38667f740c |
| children | e8b2dc771f9e |
line wrap: on
line diff
--- a/schema/tap_tests_data.sql Mon Sep 16 17:15:18 2019 +0200 +++ b/schema/tap_tests_data.sql Mon Sep 16 17:15:33 2019 +0200 @@ -16,7 +16,8 @@ -- Test data used in *_tests.sql scripts -- -INSERT INTO countries VALUES ('AT'), ('RO'), ('DE'); +INSERT INTO countries VALUES ('AT'), ('RO'), ('DE') + ON CONFLICT (country_code) DO NOTHING; INSERT INTO language_codes VALUES ('DE'); INSERT INTO depth_references VALUES ('ZPG');