# HG changeset patch # User Raimund Renkert # Date 1480504416 -3600 # Node ID 4c6f8984ff0344aa35de79d06917687a1340f87e # Parent fffd66b6ee8a577b0036f81873ab59c14deee5f6 Fixed setup db script. diff -r fffd66b6ee8a -r 4c6f8984ff03 db_schema/stammdaten_data_verwaltungseinheit.sql --- a/db_schema/stammdaten_data_verwaltungseinheit.sql Tue Nov 29 16:00:27 2016 +0100 +++ b/db_schema/stammdaten_data_verwaltungseinheit.sql Wed Nov 30 12:13:36 2016 +0100 @@ -13,7 +13,6 @@ SET standard_conforming_strings = on; SET check_function_bodies = false; SET client_min_messages = warning; -SET row_security = off; SET search_path = stammdaten, pg_catalog; diff -r fffd66b6ee8a -r 4c6f8984ff03 db_schema/stammdaten_init_sequences.sql --- a/db_schema/stammdaten_init_sequences.sql Tue Nov 29 16:00:27 2016 +0100 +++ b/db_schema/stammdaten_init_sequences.sql Wed Nov 30 12:13:36 2016 +0100 @@ -1,3 +1,5 @@ +SET search_path TO stammdaten; + SELECT pg_catalog.setval('auth_id_seq', (SELECT max(id) FROM stammdaten.auth), true); SELECT pg_catalog.setval('auth_lst_umw_id_seq', (SELECT max(id) FROM auth_lst_umw) , true); @@ -26,7 +28,7 @@ SELECT pg_catalog.setval('messgroesse_id_seq', (SELECT max(id) FROM messgroesse), true); -SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgreossen_gruppe), true); +SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgroessen_gruppe), true); SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', (SELECT max(id) FROM messprogramm_kategorie), true); @@ -38,7 +40,7 @@ SELECT pg_catalog.setval('probenehmer_id_seq', (SELECT max(id) FROM probenehmer), true); -SELECT pg_catalog.setval('query_id_seq', SELECT max(id) FROM query), true); +SELECT pg_catalog.setval('query_id_seq', (SELECT max(id) FROM query), true); SELECT pg_catalog.setval('result_id_seq', (SELECT max(id) FROM result), true);