annotate db_schema/stammdaten_data_user_context.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 4689 (class 0 OID 535738)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
24 -- Dependencies: 254
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
25 -- Data for Name: lada_user; 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 lada_user (id, name) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
29 0 default
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
30 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
31
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
32
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
33 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
34 -- TOC entry 4681 (class 0 OID 535715)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
35 -- Dependencies: 246
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
36 -- Data for Name: favorite; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
37 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
38
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
39 COPY favorite (id, user_id, query_id) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
40 \.
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
41
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
42
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
43 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
44 -- TOC entry 4685 (class 0 OID 535725)
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
45 -- Dependencies: 250
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
46 -- Data for Name: filter_value; Type: TABLE DATA; Schema: stammdaten; Owner: lada
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
47 --
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
48
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
49 COPY filter_value (id, user_id, filter_id, value) FROM stdin;
3923b41f8783 reorganize db setup
Michael Stanko <mstanko@bfs.de>
parents:
diff changeset
50 \.
This site is hosted by Intevation GmbH (Datenschutzerklärung und Impressum | Privacy Policy and Imprint)