annotate db_schema/stammdaten_data_messprogramm_transfer.sql @ 1269:3cdf75a9bf92

Check for entnahmeOrt in messprogramm and add error if missing.
author Raimund Renkert <raimund.renkert@intevation.de>
date Fri, 27 Jan 2017 16:12:52 +0100
parents 3923b41f8783
children
rev   line source
1191
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
1 \set ON_ERROR_STOP on
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
3 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
4 -- PostgreSQL database dump
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
5 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
6
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
7 -- Dumped from database version 9.5.1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
8 -- Dumped by pg_dump version 9.5.0
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
9
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
10 -- Started on 2016-03-31 11:38:13
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
11
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
12 SET statement_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
13 SET lock_timeout = 0;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
14 SET client_encoding = 'UTF8';
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
15 SET standard_conforming_strings = on;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
16 SET check_function_bodies = false;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
17 SET client_min_messages = warning;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
18
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
19 SET search_path = stammdaten, pg_catalog;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
20
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
21
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
22 COPY messprogramm_transfer (messprogramm_s, messprogramm_c, ba_id) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
23 1 Routinemessprogramm, 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 2 Intensiv- bzw. sektororientiertes Intensivmessprogramm 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 4 REI, bestimmungsgemäßer Betrieb 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
26 5 REI, Störfall/Unfall 2
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
27 6 REI, Übung zum Störfall 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
28 A Landesmessprogramm -A- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 B Landesmessprogramm -B- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 C Landesmessprogramm -C- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31 D Landesmessprogramm -D- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32 E Landesmessprogramm -E- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 F Landesmessprogramm -F- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 G Landesmessprogramm -G- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 H Landesmessprogramm -H- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 I Landesmessprogramm -I- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 J Landesmessprogramm -J- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38 K Landesmessprogramm -K- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 L Landesmessprogramm -L- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 M Landesmessprogramm -M- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41 N Landesmessprogramm -N- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42 O Landesmessprogramm -O- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 P Landesmessprogramm -P- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 Q Landesmessprogramm -Q- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 R Landesmessprogramm -R- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 S Landesmessprogramm -S- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 T Landesmessprogramm -T- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
48 U Landesmessprogramm -U- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
49 V Landesmessprogramm -V- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
50 W Landesmessprogramm -W- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
51 X Landesmessprogramm -X- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
52 Y Landesmessprogramm -Y- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
53 Z Landesmessprogramm -Z- 1
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
54 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)