view db_schema/stammdaten_data_messprogramm_transfer.sql @ 1313:b5ab25b7ac2c

Stop on error any execution of SQL via psql in DB setup. Though this duplicates respective \set commands in many scripts, I leave them there because they might help in debugging anyhow. Hopefully this change will improve prevention of adding broken SQL like currently audit.sql.
author Tom Gottfried <tom@intevation.de>
date Fri, 17 Mar 2017 12:52:23 +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;


COPY messprogramm_transfer (messprogramm_s, messprogramm_c, ba_id) FROM stdin;
1	Routinemessprogramm,	1
2	Intensiv- bzw. sektororientiertes Intensivmessprogramm	2
4	REI, bestimmungsgemäßer Betrieb	1
5	REI, Störfall/Unfall	2
6	REI, Übung zum Störfall	1
A	Landesmessprogramm -A-	1
B	Landesmessprogramm -B-	1
C	Landesmessprogramm -C-	1
D	Landesmessprogramm -D-	1
E	Landesmessprogramm -E-	1
F	Landesmessprogramm -F-	1
G	Landesmessprogramm -G-	1
H	Landesmessprogramm -H-	1
I	Landesmessprogramm -I-	1
J	Landesmessprogramm -J-	1
K	Landesmessprogramm -K-	1
L	Landesmessprogramm -L-	1
M	Landesmessprogramm -M-	1
N	Landesmessprogramm -N-	1
O	Landesmessprogramm -O-	1
P	Landesmessprogramm -P-	1
Q	Landesmessprogramm -Q-	1
R	Landesmessprogramm -R-	1
S	Landesmessprogramm -S-	1
T	Landesmessprogramm -T-	1
U	Landesmessprogramm -U-	1
V	Landesmessprogramm -V-	1
W	Landesmessprogramm -W-	1
X	Landesmessprogramm -X-	1
Y	Landesmessprogramm -Y-	1
Z	Landesmessprogramm -Z-	1
\.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)