view db_schema/stammdaten_data_pflicht_messgroesse.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 3923b41f8783
children
line wrap: on
line source
\set ON_ERROR_STOP on

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.5.1
-- Dumped by pg_dump version 9.5.0

-- Started on 2016-03-31 11:38:13

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

SET search_path = stammdaten, pg_catalog;

--
-- TOC entry 4708 (class 0 OID 535805)
-- Dependencies: 274
-- Data for Name: pflicht_messgroesse; Type: TABLE DATA; Schema: stammdaten; Owner: lada
--

COPY pflicht_messgroesse (id, messgroesse_id, mmt_id, umw_id, datenbasis_id) FROM stdin;
102	404	G1	A	2
103	369	G1	A	2
104	340	G1	A	2
105	220	G1	A	2
110	404	G1	F	2
111	369	G1	F	2
112	340	G1	F	2
113	220	G1	F	2
114	404	G1	G	2
115	369	G1	G	2
116	340	G1	G	2
117	220	G1	G	2
122	404	G1	L5	2
123	369	G1	L5	2
124	340	G1	L5	2
125	220	G1	L5	2
126	404	G1	N	2
127	369	G1	N	2
128	340	G1	N	2
129	220	G1	N	2
130	404	G1	Z	2
131	369	G1	Z	2
132	340	G1	Z	2
133	220	G1	Z	2
32	904	A2	A13	4
33	904	A3	B2	4
34	902	B3	B2	4
35	68	G1	B3	4
36	68	G1	F1	4
37	1	BH	F1	4
38	5	BC	F11	4
59	68	G1	G4	4
60	904	A2	G4	4
61	1	BH	G4	4
62	165	BS	G4	4
39	68	G1	F2	4
40	5	BC	F2	4
41	68	G1	F3	4
42	5	BC	F3	4
43	1	BH	F3	4
44	68	G1	F4	4
45	165	BS	F4	4
46	68	G1	F5	4
47	5	BC	F51	4
48	1	BH	F51	4
49	5	BC	F52	4
50	1	BH	F52	4
51	165	BS	F5Z	4
52	68	G1	G1	4
53	904	A2	G11	4
54	1	BH	G11	4
55	68	G1	G21	4
56	904	A2	G21	4
57	1	BH	G21	4
58	68	G1	G23	4
63	68	G1	G5	4
64	1	BH	G5	4
65	165	BS	G5	4
66	904	A2	G51	4
67	904	A2	G53	4
68	68	G1	GZ	4
69	904	A2	GZ	4
70	1	BH	GZ	4
80	930	O2	L22	4
83	68	G1	N11	4
84	340	GI	N11	4
85	165	BS	N11	4
86	68	G1	N12	4
87	340	GI	N12	4
88	165	BS	N12	4
89	68	G1	N2	4
90	165	BS	N2	4
91	68	G1	N31	4
92	165	BS	N31	4
93	68	G1	N4	4
94	165	BS	N4	4
95	68	G1	N55	4
96	373	G1	N55	4
97	68	G1	N61	4
98	68	G1	N62	4
99	68	G1	N7	4
100	1	BH	N7	4
101	165	BS	N7	4
71	68	G1	I13	4
72	5	BC	I13	4
73	1	BH	I13	4
76	928	D2	L21	4
77	68	G1	L31	4
78	904	A2	L31	4
79	340	GI	L41	4
81	68	G1	L5	4
82	904	A2	L5	4
1	28	G1	A	2
2	68	G1	A	2
3	373	G1	A	2
4	28	G1	B	2
5	68	G1	B	2
6	373	G1	B	2
7	28	G1	F	2
8	68	G1	F	2
9	373	G1	F	2
10	28	G1	G	2
11	68	G1	G	2
12	373	G1	G	2
13	28	G1	I	2
14	68	G1	I	2
15	373	G1	I	2
16	2	G1	L3	2
17	68	G1	L3	2
18	373	G1	L3	2
19	340	G1	L41	2
20	28	G1	L5	2
21	68	G1	L5	2
22	373	G1	L5	2
23	28	G1	N	2
24	68	G1	N	2
25	373	G1	N	2
26	28	G1	Z	2
27	68	G1	Z	2
28	373	G1	Z	2
29	369	G1	L3	2
30	672	G1	L3	2
31	673	G1	L3	2
106	404	G1	B	2
107	369	G1	B	2
108	340	G1	B	2
109	220	G1	B	2
118	404	G1	I	2
119	369	G1	I	2
120	340	G1	I	2
121	220	G1	I	2
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)