Mercurial > gemma
changeset 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 | 9c6c65a628a3 |
| children | 7657640f0c8d |
| files | schema/tap_tests_data.sql |
| diffstat | 1 files changed, 2 insertions(+), 1 deletions(-) [+] |
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');