|
1
|
CREATE FUNCTION TSystem.views__all__drop() RETURNS void AS $$
|
|
2
|
BEGIN
|
|
3
|
|
|
4
|
|
|
5
|
RETURN;
|
|
6
|
END $$ LANGUAGE plpgsql;
|
|
7
|
--
|
|
8
|
|
|
9
|
--
|
|
10
|
CREATE FUNCTION TSystem.views__all__create() RETURNS VOID AS $$
|
|
11
|
BEGIN
|
|
12
|
|
|
13
|
RETURN;
|
|
14
|
END $$ LANGUAGE plpgsql;
|
|
15
|
--
|
|
16
|
|
|
17
|
--
|
|
18
|
|
|
19
|
CREATE FUNCTION TSystem.views__Adressen__recreate() RETURNS VOID AS $$
|
|
20
|
BEGIN
|
|
21
|
DROP VIEW IF EXISTS adressen_view CASCADE;
|
|
22
|
|
|
23
|
CREATE OR REPLACE VIEW adressen_view AS
|
|
24
|
SELECT
|
|
25
|
dbrid,
|
|
26
|
ad_krz AS adk_ad_krz,
|
|
27
|
ad_krz,
|
|
28
|
ad_fa1,
|
|
29
|
ad_fa2,
|
|
30
|
ad_adrzus,
|
|
31
|
ad_anr,
|
|
32
|
ad_titel,
|
|
33
|
ad_name,
|
|
34
|
ad_vorn,
|
|
35
|
ad_str,
|
|
36
|
ad_plz,
|
|
37
|
ad_ort,
|
|
38
|
ad_landiso::VARCHAR(5),
|
|
39
|
ad_land,
|
|
40
|
ad_pfc,
|
|
41
|
ad_fax,
|
|
42
|
ad_tel1,
|
|
43
|
ad_tel2,
|
|
44
|
ad_email1,
|
|
45
|
ad_email2,
|
|
46
|
ad_such,
|
|
47
|
ad_ustidnr,
|
|
48
|
ad_branche,
|
|
49
|
ad_stat,
|
|
50
|
ad_bem,
|
|
51
|
adk.modified_date,
|
|
52
|
ad_auslauf
|
|
53
|
FROM adk ;
|
|
54
|
|
|
55
|
RETURN;
|
|
56
|
END $$ LANGUAGE plpgsql;
|
|
57
|
|
|
58
|
SELECT TSystem.views__Adressen__recreate();
|
|
59
|
|
|
60
|
CREATE SCHEMA IF NOT EXISTS tCache;
|
|
61
|
|
|
62
|
|
|
63
|
do $f$
|
|
64
|
BEGIN
|
|
65
|
BEGIN
|
|
66
|
EXECUTE $f2$
|
|
67
|
CREATE FUNCTION TCache.CachedViews_Clear() RETURNS BOOLEAN AS $$
|
|
68
|
DECLARE
|
|
69
|
r RECORD;
|
|
70
|
e BOOLEAN;
|
|
71
|
BEGIN
|
|
72
|
|
|
73
|
RETURN false;
|
|
74
|
END $$ LANGUAGE plpgsql;
|
|
75
|
$f2$;
|
|
76
|
EXCEPTION WHEN others THEN null; END;
|
|
77
|
END
|
|
78
|
$f$ LANGUAGE plpgsql;
|
|
79
|
|
|
80
|
do $f$
|
|
81
|
BEGIN
|
|
82
|
BEGIN
|
|
83
|
EXECUTE $f2$
|
|
84
|
CREATE FUNCTION
|
|
85
|
/*Delete für alle Tabellen setzen!!!!!*/
|
|
86
|
CREATE FUNCTION table_delete() RETURNS TRIGGER AS $$
|
|
87
|
BEGIN
|
|
88
|
|
|
89
|
|
|
90
|
RETURN old;
|
|
91
|
END $$ LANGUAGE plpgsql;
|
|
92
|
$f2$;
|
|
93
|
EXCEPTION WHEN others THEN null; END;
|
|
94
|
END
|
|
95
|
$f$ LANGUAGE plpgsql;
|
|
96
|
|
|
97
|
|
|
98
|
do $f$
|
|
99
|
BEGIN
|
|
100
|
BEGIN
|
|
101
|
EXECUTE $f2$
|
|
102
|
CREATE FUNCTION TSystem.views__ReportingAuftg__recreate() RETURNS VOID AS $$
|
|
103
|
BEGIN
|
|
104
|
|
|
105
|
DROP VIEW IF EXISTS treporting.auftg_beleg_positionennachtrag;
|
|
106
|
DROP VIEW IF EXISTS treporting.auftg_beleg_positionen;
|
|
107
|
|
|
108
|
|
|
109
|
END $$ LANGUAGE plpgsql;
|
|
110
|
$f2$;
|
|
111
|
EXCEPTION WHEN others THEN null; END;
|
|
112
|
END
|
|
113
|
$f$ LANGUAGE plpgsql;
|
|
114
|
|
|
115
|
do $f$
|
|
116
|
BEGIN
|
|
117
|
BEGIN
|
|
118
|
EXECUTE $f2$
|
|
119
|
--/*
|
|
120
|
CREATE FUNCTION treporting.recreatereportingauftgviews( ) RETURNS void AS $$
|
|
121
|
BEGIN
|
|
122
|
RETURN;
|
|
123
|
END $$ LANGUAGE plpgsql;
|
|
124
|
--*/
|
|
125
|
END $$ LANGUAGE plpgsql;
|
|
126
|
$f2$;
|
|
127
|
EXCEPTION WHEN others THEN null; END;
|
|
128
|
END
|
|
129
|
$f$ LANGUAGE plpgsql;
|
|
130
|
|
|
131
|
|
|
132
|
CREATE OR REPLACE FUNCTION treporting.RecreateViews() RETURNS void AS $$
|
|
133
|
BEGIN
|
|
134
|
RETURN;
|
|
135
|
END $$ LANGUAGE plpgsql;
|
|
136
|
|
|
137
|
CREATE OR REPLACE FUNCTION TWawi.RecreateViews() RETURNS void AS $$
|
|
138
|
BEGIN
|
|
139
|
RETURN;
|
|
140
|
END $$ LANGUAGE plpgsql;
|
|
141
|
|
|
142
|
|
|
143
|
CREATE OR REPLACE FUNCTION DropBelegViews() RETURNS VOID AS $$
|
|
144
|
BEGIN
|
|
145
|
DROP VIEW IF EXISTS eingrech;
|
|
146
|
DROP VIEW IF EXISTS eingrech_pos;
|
|
147
|
DROP VIEW IF EXISTS lieferschein;
|
|
148
|
DROP VIEW IF EXISTS lieferschein_pos;
|
|
149
|
END $$ LANGUAGE plpgsql;
|
|
150
|
|
|
151
|
do $f$
|
|
152
|
BEGIN
|
|
153
|
BEGIN
|
|
154
|
EXECUTE $f2$
|
|
155
|
CREATE FUNCTION lang_versart(INTEGER, VARCHAR) RETURNS VARCHAR AS $$ -- #7137
|
|
156
|
BEGIN
|
|
157
|
|
|
158
|
RETURN null;
|
|
159
|
END $$ LANGUAGE plpgsql;
|
|
160
|
$f2$;
|
|
161
|
EXCEPTION WHEN others THEN null; END;
|
|
162
|
END
|
|
163
|
$f$ LANGUAGE plpgsql;
|