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
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)