Mercurial > lada > lada-server
annotate db_schema/stammdaten_init_sequences.sql @ 1315:84bb7e2aecb1
Do not redefine existing operator.
The removed SQL failed on PostgreSQL 9.5 because the operator is
provided and needed by the system. Further, it does not seem to be
used here.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 17 Mar 2017 13:25:57 +0100 |
parents | 4c6f8984ff03 |
children |
rev | line source |
---|---|
1197
4c6f8984ff03
Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
1191
diff
changeset
|
1 SET search_path TO stammdaten; |
4c6f8984ff03
Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
1191
diff
changeset
|
2 |
1191 | 3 SELECT pg_catalog.setval('auth_id_seq', (SELECT max(id) FROM stammdaten.auth), true); |
4 | |
5 SELECT pg_catalog.setval('auth_lst_umw_id_seq', (SELECT max(id) FROM auth_lst_umw) , true); | |
6 | |
7 SELECT pg_catalog.setval('datenbasis_id_seq', (SELECT max(id) FROM datenbasis), true); | |
8 | |
9 SELECT pg_catalog.setval('datensatz_erzeuger_id_seq', (SELECT max(id) FROM datensatz_erzeuger), true); | |
10 | |
11 SELECT pg_catalog.setval('deskriptor_umwelt_id_seq', (SELECT max(id) FROM deskriptor_umwelt), true); | |
12 | |
13 SELECT pg_catalog.setval('deskriptoren_id_seq', (SELECT max(id) FROM deskriptoren), true); | |
14 | |
15 SELECT pg_catalog.setval('favorite_id_seq', 1, false); | |
16 | |
17 SELECT pg_catalog.setval('filter_id_seq', (SELECT max(id) FROM filter), true); | |
18 | |
19 SELECT pg_catalog.setval('filter_value_id_seq', 1, false); | |
20 | |
21 SELECT pg_catalog.setval('koordinaten_art_id_seq', (SELECT max(id) FROM koordinaten_art), true); | |
22 | |
23 SELECT pg_catalog.setval('kta_id_seq', (SELECT max(id) FROM kta), true); | |
24 | |
25 SELECT pg_catalog.setval('lada_user_id_seq', 1, false); | |
26 | |
27 SELECT pg_catalog.setval('mess_einheit_id_seq', (SELECT max(id) FROM mess_einheit), true); | |
28 | |
29 SELECT pg_catalog.setval('messgroesse_id_seq', (SELECT max(id) FROM messgroesse), true); | |
30 | |
1197
4c6f8984ff03
Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
1191
diff
changeset
|
31 SELECT pg_catalog.setval('messgroessen_gruppe_id_seq', (SELECT max(id) FROM messgroessen_gruppe), true); |
1191 | 32 |
33 SELECT pg_catalog.setval('messprogramm_kategorie_id_seq', (SELECT max(id) FROM messprogramm_kategorie), true); | |
34 | |
35 SELECT pg_catalog.setval('ort_id_seq', (SELECT max(id) FROM ort), true); | |
36 | |
37 SELECT pg_catalog.setval('pflicht_messgroesse_id_seq', (SELECT max(id) FROM pflicht_messgroesse), true); | |
38 | |
39 SELECT pg_catalog.setval('probenart_id_seq', (SELECT max(id) FROM probenart), true); | |
40 | |
41 SELECT pg_catalog.setval('probenehmer_id_seq', (SELECT max(id) FROM probenehmer), true); | |
42 | |
1197
4c6f8984ff03
Fixed setup db script.
Raimund Renkert <raimund.renkert@intevation.de>
parents:
1191
diff
changeset
|
43 SELECT pg_catalog.setval('query_id_seq', (SELECT max(id) FROM query), true); |
1191 | 44 |
45 SELECT pg_catalog.setval('result_id_seq', (SELECT max(id) FROM result), true); | |
46 | |
47 SELECT pg_catalog.setval('staat_id_seq', (SELECT max(id) FROM staat), true); |