# HG changeset patch # User Tom Gottfried # Date 1460111554 -7200 # Node ID adc0a47b7b9d5e931355c0e9a2e68f92e65628ff # Parent d8c66007fa1419500a8a0f975b1a677715ce5f6f Sequences in bund schema have to be set to correct values. This is because the inheriting tables use these sequences too. diff -r d8c66007fa14 -r adc0a47b7b9d db_schema/lada_data.sql --- 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