Mercurial > lada > lada-server
diff db_schema/lada_data.sql @ 913:adc0a47b7b9d
Sequences in bund schema have to be set to correct values.
This is because the inheriting tables use these sequences too.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Fri, 08 Apr 2016 12:32:34 +0200 |
| parents | 8c61587f7a7b |
| children | 6ab17d8b5558 |
line wrap: on
line diff
--- a/db_schema/lada_data.sql Fri Apr 08 11:14:09 2016 +0200 +++ b/db_schema/lada_data.sql Fri Apr 08 12:32:34 2016 +0200 @@ -2,11 +2,6 @@ -- PostgreSQL database dump -- --- Dumped from database version 9.5.1 --- Dumped by pg_dump version 9.5.0 - --- Started on 2016-03-31 11:55:47 - SET statement_timeout = 0; SET lock_timeout = 0; SET client_encoding = 'UTF8'; @@ -14,6 +9,7 @@ SET check_function_bodies = false; SET client_min_messages = warning; + SET search_path = land, pg_catalog; -- @@ -1235,7 +1231,22 @@ ALTER TABLE zusatz_wert ENABLE TRIGGER ALL; --- Completed on 2016-03-31 11:55:55 + + +SET search_path = bund, pg_catalog; + +SELECT pg_catalog.setval('kommentar_id_seq', 661, true); + +SELECT pg_catalog.setval('messung_id_seq', 1009, true); + +SELECT pg_catalog.setval('messwert_id_seq', 6471, true); + +SELECT pg_catalog.setval('ort_id_seq', 921, true); + +SELECT pg_catalog.setval('probe_id_seq', 733, true); + +SELECT pg_catalog.setval('zusatz_wert_id_seq', 30, true); + -- -- PostgreSQL database dump complete