lada/lada-server: db_schema/stammdaten_data

annotate db_schema/stammdaten_data_probenart.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

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 --
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	23 -- TOC entry 4711 (class 0 OID 535813)
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	24 -- Dependencies: 277
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	25 -- Data for Name: probenart; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	26 --
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	27
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	28 COPY probenart (id, beschreibung, probenart, probenart_eudf_id) FROM stdin;
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	29 1 Einzelprobe E A
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	30 2 Mischprobe M A
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	31 3 Sammelprobe S A
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	32 9 kontinuierliche Probe X A
3923b41f8783 reorganize db setup Michael Stanko <mstanko@bfs.de> parents: diff changeset	33 \.

Mercurial > lada > lada-server

annotate db_schema/stammdaten_data_probenart.sql @ 1315:84bb7e2aecb1