Mercurial > lada > lada-server
annotate db_schema/stammdaten_data_ort_typ.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 | a4c7057cbaed |
| children | 3ac30d816c9a |
| rev | line source |
|---|---|
| 1191 | 1 \set ON_ERROR_STOP on |
| 2 | |
| 3 -- | |
| 4 -- PostgreSQL database dump | |
| 5 -- | |
| 6 | |
| 7 -- Dumped from database version 9.5.1 | |
| 8 -- Dumped by pg_dump version 9.5.0 | |
| 9 | |
| 10 -- Started on 2016-03-31 11:38:13 | |
| 11 | |
| 12 SET statement_timeout = 0; | |
| 13 SET lock_timeout = 0; | |
| 14 SET client_encoding = 'UTF8'; | |
| 15 SET standard_conforming_strings = on; | |
| 16 SET check_function_bodies = false; | |
| 17 SET client_min_messages = warning; | |
| 18 | |
| 19 SET search_path = stammdaten, pg_catalog; | |
| 20 | |
| 21 | |
| 22 -- | |
| 23 -- TOC entry 4706 (class 0 OID 535799) | |
| 24 -- Dependencies: 272 | |
| 25 -- Data for Name: ort_typ; Type: TABLE DATA; Schema: stammdaten; Owner: lada | |
| 26 -- | |
| 27 | |
|
1258
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
28 COPY ort_typ (id, ort_typ, code) FROM stdin; |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
29 1 dynamischer Messpunkt (nicht vordefiniert) DYN |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
30 2 vordefinierter Messpunkt GP |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
31 3 REI-Messpunkit REI |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
32 4 Verwaltungseinheit VE |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
33 5 Staat ST |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
34 6 Fluss FL |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
35 7 See SEE |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
36 8 Wasserwerk WW |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
37 9 Kläranlage KA |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
38 10 Deponie DEP |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
39 11 Müllverbrennungsanlage MVA |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
40 12 Messstation MST |
|
cb88ab44c2be
add code to stamdaten.ort_typ
Michael Stanko <mstanko@bfs.de>
parents:
1191
diff
changeset
|
41 13 KTA KTA |
| 1191 | 42 \. |
| 43 |