blob: da9297d8b611f61cb15f554742231f8d0a7ef60f (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
|
--
-- drop.source
--
--
-- this will fail if the user is not the postgres superuser.
-- if it does, don't worry about it (you can turn usersuper
-- back on as "postgres"). too many people don't follow
-- directions and run this as "postgres", though...
--
UPDATE pg_user
SET usesuper = 't'::bool
WHERE usename = 'postgres';
--
-- FUNCTION REMOVAL
--
DROP FUNCTION hobbies(person);
DROP FUNCTION hobby_construct(text,text);
DROP FUNCTION equipment(hobbies_r);
DROP FUNCTION user_relns();
DROP FUNCTION widget_in(cstring);
DROP FUNCTION widget_out(widget);
DROP FUNCTION pt_in_widget(point,widget);
DROP FUNCTION overpaid(emp);
DROP FUNCTION boxarea(box);
DROP FUNCTION interpt_pp(path,path);
DROP FUNCTION reverse_name(name);
DROP FUNCTION oldstyle_length(int4, text);
--
-- OPERATOR REMOVAL
--
DROP OPERATOR ## (path, path);
DROP OPERATOR <% (point, widget);
-- left unary
DROP OPERATOR @#@ (none, int4);
-- right unary
DROP OPERATOR #@# (int4, none);
-- right unary
DROP OPERATOR #%# (int4, none);
--
-- ABSTRACT DATA TYPE REMOVAL
--
DROP TYPE city_budget;
DROP TYPE widget;
--
-- RULE REMOVAL
-- (is also tested in queries.source)
--
--
-- AGGREGATE REMOVAL
--
DROP AGGREGATE newavg (int4);
DROP AGGREGATE newsum (int4);
DROP AGGREGATE newcnt (int4);
--
-- CLASS REMOVAL
-- (inheritance hierarchies are deleted in reverse order)
--
--
-- DROP ancillary data structures (i.e. indices)
--
DROP INDEX onek_unique1;
DROP INDEX onek_unique2;
DROP INDEX onek_hundred;
DROP INDEX onek_stringu1;
DROP INDEX tenk1_unique1;
DROP INDEX tenk1_unique2;
DROP INDEX tenk1_hundred;
DROP INDEX tenk2_unique1;
DROP INDEX tenk2_unique2;
DROP INDEX tenk2_hundred;
-- DROP INDEX onek2_u1_prtl;
-- DROP INDEX onek2_u2_prtl;
-- DROP INDEX onek2_stu1_prtl;
DROP INDEX rect2ind;
DROP INDEX rix;
DROP INDEX iix;
DROP INDEX six;
DROP INDEX hash_i4_index;
DROP INDEX hash_name_index;
DROP INDEX hash_txt_index;
DROP INDEX hash_f8_index;
-- DROP INDEX hash_ovfl_index;
DROP INDEX bt_i4_index;
DROP INDEX bt_name_index;
DROP INDEX bt_txt_index;
DROP INDEX bt_f8_index;
DROP TABLE onek;
DROP TABLE onek2;
DROP TABLE tenk1;
DROP TABLE tenk2;
DROP TABLE Bprime;
DROP TABLE hobbies_r;
DROP TABLE equipment_r;
DROP TABLE aggtest;
DROP TABLE xacttest;
DROP TABLE arrtest;
DROP TABLE iportaltest;
DROP TABLE f_star;
DROP TABLE e_star;
DROP TABLE d_star;
DROP TABLE c_star;
DROP TABLE b_star;
DROP TABLE a_star;
--
-- must be in reverse inheritance order
--
DROP TABLE stud_emp;
DROP TABLE student;
DROP TABLE slow_emp4000;
DROP TABLE fast_emp4000;
DROP TABLE emp;
DROP TABLE person;
DROP TABLE ramp;
DROP TABLE real_city;
DROP TABLE dept;
DROP TABLE ihighway;
DROP TABLE shighway;
DROP TABLE road;
DROP TABLE city;
DROP TABLE hash_i4_heap;
DROP TABLE hash_name_heap;
DROP TABLE hash_txt_heap;
DROP TABLE hash_f8_heap;
-- DROP TABLE hash_ovfl_heap;
DROP TABLE bt_i4_heap;
DROP TABLE bt_name_heap;
DROP TABLE bt_txt_heap;
DROP TABLE bt_f8_heap;
DROP TABLE ABSTIME_TBL;
DROP TABLE RELTIME_TBL;
DROP TABLE TINTERVAL_TBL;
--
-- VIRTUAL CLASS REMOVAL
-- (also tests removal of rewrite rules)
--
DROP VIEW street;
DROP VIEW iexit;
DROP VIEW toyemp;
|
