← Back to branch summary

~ubuntu-branches/ubuntu/natty/postgresql-8.4/natty-updates

« back to all changes in this revision

Viewing changes to contrib/btree_gist/uninstall_btree_gist.sql

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2009-03-20 12:00:13 UTC
  • Revision ID: james.westby@ubuntu.com-20090320120013-hogj7egc5mjncc5g
Tags: upstream-8.4~0cvs20090328
Import upstream version 8.4~0cvs20090328

Show diffs side-by-side

added added

removed removed

Lines of Context:
contrib/btree_gist/uninstall_btree_gist.sql
 
1
/* $PostgreSQL$ */
 
2
 
 
3
-- Adjust this setting to control where the objects get dropped.
 
4
SET search_path = public;
 
5
 
 
6
DROP OPERATOR CLASS gist_cidr_ops USING gist;
 
7
 
 
8
DROP OPERATOR CLASS gist_inet_ops USING gist;
 
9
 
 
10
DROP FUNCTION gbt_inet_same(internal, internal, internal);
 
11
 
 
12
DROP FUNCTION gbt_inet_union(bytea, internal);
 
13
 
 
14
DROP FUNCTION gbt_inet_picksplit(internal, internal);
 
15
 
 
16
DROP FUNCTION gbt_inet_penalty(internal,internal,internal);
 
17
 
 
18
DROP FUNCTION gbt_inet_compress(internal);
 
19
 
 
20
DROP FUNCTION gbt_inet_consistent(internal,inet,int2,oid,internal);
 
21
 
 
22
DROP OPERATOR CLASS gist_vbit_ops USING gist;
 
23
 
 
24
DROP OPERATOR CLASS gist_bit_ops USING gist;
 
25
 
 
26
DROP FUNCTION gbt_bit_same(internal, internal, internal);
 
27
 
 
28
DROP FUNCTION gbt_bit_union(bytea, internal);
 
29
 
 
30
DROP FUNCTION gbt_bit_picksplit(internal, internal);
 
31
 
 
32
DROP FUNCTION gbt_bit_penalty(internal,internal,internal);
 
33
 
 
34
DROP FUNCTION gbt_bit_compress(internal);
 
35
 
 
36
DROP FUNCTION gbt_bit_consistent(internal,bit,int2,oid,internal);
 
37
 
 
38
DROP OPERATOR CLASS gist_numeric_ops USING gist;
 
39
 
 
40
DROP FUNCTION gbt_numeric_same(internal, internal, internal);
 
41
 
 
42
DROP FUNCTION gbt_numeric_union(bytea, internal);
 
43
 
 
44
DROP FUNCTION gbt_numeric_picksplit(internal, internal);
 
45
 
 
46
DROP FUNCTION gbt_numeric_penalty(internal,internal,internal);
 
47
 
 
48
DROP FUNCTION gbt_numeric_compress(internal);
 
49
 
 
50
DROP FUNCTION gbt_numeric_consistent(internal,numeric,int2,oid,internal);
 
51
 
 
52
DROP OPERATOR CLASS gist_bytea_ops USING gist;
 
53
 
 
54
DROP FUNCTION gbt_bytea_same(internal, internal, internal);
 
55
 
 
56
DROP FUNCTION gbt_bytea_union(bytea, internal);
 
57
 
 
58
DROP FUNCTION gbt_bytea_picksplit(internal, internal);
 
59
 
 
60
DROP FUNCTION gbt_bytea_penalty(internal,internal,internal);
 
61
 
 
62
DROP FUNCTION gbt_bytea_compress(internal);
 
63
 
 
64
DROP FUNCTION gbt_bytea_consistent(internal,bytea,int2,oid,internal);
 
65
 
 
66
DROP OPERATOR CLASS gist_bpchar_ops USING gist;
 
67
 
 
68
DROP OPERATOR CLASS gist_text_ops USING gist;
 
69
 
 
70
DROP FUNCTION gbt_text_same(internal, internal, internal);
 
71
 
 
72
DROP FUNCTION gbt_text_union(bytea, internal);
 
73
 
 
74
DROP FUNCTION gbt_text_picksplit(internal, internal);
 
75
 
 
76
DROP FUNCTION gbt_text_penalty(internal,internal,internal);
 
77
 
 
78
DROP FUNCTION gbt_bpchar_compress(internal);
 
79
 
 
80
DROP FUNCTION gbt_text_compress(internal);
 
81
 
 
82
DROP FUNCTION gbt_bpchar_consistent(internal,bpchar,int2,oid,internal);
 
83
 
 
84
DROP FUNCTION gbt_text_consistent(internal,text,int2,oid,internal);
 
85
 
 
86
DROP OPERATOR CLASS gist_macaddr_ops USING gist;
 
87
 
 
88
DROP FUNCTION gbt_macad_same(internal, internal, internal);
 
89
 
 
90
DROP FUNCTION gbt_macad_union(bytea, internal);
 
91
 
 
92
DROP FUNCTION gbt_macad_picksplit(internal, internal);
 
93
 
 
94
DROP FUNCTION gbt_macad_penalty(internal,internal,internal);
 
95
 
 
96
DROP FUNCTION gbt_macad_compress(internal);
 
97
 
 
98
DROP FUNCTION gbt_macad_consistent(internal,macaddr,int2,oid,internal);
 
99
 
 
100
DROP OPERATOR CLASS gist_cash_ops USING gist;
 
101
 
 
102
DROP FUNCTION gbt_cash_same(internal, internal, internal);
 
103
 
 
104
DROP FUNCTION gbt_cash_union(bytea, internal);
 
105
 
 
106
DROP FUNCTION gbt_cash_picksplit(internal, internal);
 
107
 
 
108
DROP FUNCTION gbt_cash_penalty(internal,internal,internal);
 
109
 
 
110
DROP FUNCTION gbt_cash_compress(internal);
 
111
 
 
112
DROP FUNCTION gbt_cash_consistent(internal,money,int2,oid,internal);
 
113
 
 
114
DROP OPERATOR CLASS gist_interval_ops USING gist;
 
115
 
 
116
DROP FUNCTION gbt_intv_same(internal, internal, internal);
 
117
 
 
118
DROP FUNCTION gbt_intv_union(bytea, internal);
 
119
      
 
120
DROP FUNCTION gbt_intv_picksplit(internal, internal);
 
121
   
 
122
DROP FUNCTION gbt_intv_penalty(internal,internal,internal);
 
123
 
 
124
DROP FUNCTION gbt_intv_decompress(internal);
 
125
 
 
126
DROP FUNCTION gbt_intv_compress(internal);
 
127
 
 
128
DROP FUNCTION gbt_intv_consistent(internal,interval,int2,oid,internal);
 
129
 
 
130
DROP OPERATOR CLASS gist_date_ops USING gist;
 
131
 
 
132
DROP FUNCTION gbt_date_same(internal, internal, internal);
 
133
 
 
134
DROP FUNCTION gbt_date_union(bytea, internal);
 
135
      
 
136
DROP FUNCTION gbt_date_picksplit(internal, internal);
 
137
   
 
138
DROP FUNCTION gbt_date_penalty(internal,internal,internal);
 
139
 
 
140
DROP FUNCTION gbt_date_compress(internal);
 
141
 
 
142
DROP FUNCTION gbt_date_consistent(internal,date,int2,oid,internal);
 
143
 
 
144
DROP OPERATOR CLASS gist_timetz_ops USING gist;
 
145
 
 
146
DROP OPERATOR CLASS gist_time_ops USING gist;
 
147
 
 
148
DROP FUNCTION gbt_time_same(internal, internal, internal);
 
149
 
 
150
DROP FUNCTION gbt_time_union(bytea, internal);
 
151
      
 
152
DROP FUNCTION gbt_time_picksplit(internal, internal);
 
153
   
 
154
DROP FUNCTION gbt_time_penalty(internal,internal,internal);
 
155
 
 
156
DROP FUNCTION gbt_timetz_compress(internal);
 
157
 
 
158
DROP FUNCTION gbt_time_compress(internal);
 
159
 
 
160
DROP FUNCTION gbt_timetz_consistent(internal,timetz,int2,oid,internal);
 
161
 
 
162
DROP FUNCTION gbt_time_consistent(internal,time,int2,oid,internal);
 
163
 
 
164
DROP OPERATOR CLASS gist_timestamptz_ops USING gist;
 
165
 
 
166
DROP OPERATOR CLASS gist_timestamp_ops USING gist;
 
167
 
 
168
DROP FUNCTION gbt_ts_same(internal, internal, internal);
 
169
 
 
170
DROP FUNCTION gbt_ts_union(bytea, internal);
 
171
      
 
172
DROP FUNCTION gbt_ts_picksplit(internal, internal);
 
173
   
 
174
DROP FUNCTION gbt_ts_penalty(internal,internal,internal);
 
175
 
 
176
DROP FUNCTION gbt_tstz_compress(internal);
 
177
 
 
178
DROP FUNCTION gbt_ts_compress(internal);
 
179
      
 
180
DROP FUNCTION gbt_tstz_consistent(internal,timestamptz,int2,oid,internal);
 
181
 
 
182
DROP FUNCTION gbt_ts_consistent(internal,timestamp,int2,oid,internal);
 
183
 
 
184
DROP OPERATOR CLASS gist_float8_ops USING gist;
 
185
 
 
186
DROP FUNCTION gbt_float8_same(internal, internal, internal);
 
187
 
 
188
DROP FUNCTION gbt_float8_union(bytea, internal);
 
189
 
 
190
DROP FUNCTION gbt_float8_picksplit(internal, internal);
 
191
 
 
192
DROP FUNCTION gbt_float8_penalty(internal,internal,internal);
 
193
 
 
194
DROP FUNCTION gbt_float8_compress(internal);
 
195
 
 
196
DROP FUNCTION gbt_float8_consistent(internal,float8,int2,oid,internal);
 
197
 
 
198
DROP OPERATOR CLASS gist_float4_ops USING gist;
 
199
 
 
200
DROP FUNCTION gbt_float4_same(internal, internal, internal);
 
201
 
 
202
DROP FUNCTION gbt_float4_union(bytea, internal);
 
203
 
 
204
DROP FUNCTION gbt_float4_picksplit(internal, internal);
 
205
 
 
206
DROP FUNCTION gbt_float4_penalty(internal,internal,internal);
 
207
 
 
208
DROP FUNCTION gbt_float4_compress(internal);
 
209
 
 
210
DROP FUNCTION gbt_float4_consistent(internal,float4,int2,oid,internal);
 
211
 
 
212
DROP OPERATOR CLASS gist_int8_ops USING gist;
 
213
 
 
214
DROP FUNCTION gbt_int8_same(internal, internal, internal);
 
215
 
 
216
DROP FUNCTION gbt_int8_union(bytea, internal);
 
217
 
 
218
DROP FUNCTION gbt_int8_picksplit(internal, internal);
 
219
 
 
220
DROP FUNCTION gbt_int8_penalty(internal,internal,internal);
 
221
 
 
222
DROP FUNCTION gbt_int8_compress(internal);
 
223
 
 
224
DROP FUNCTION gbt_int8_consistent(internal,int8,int2,oid,internal);
 
225
 
 
226
DROP OPERATOR CLASS gist_int4_ops USING gist;
 
227
 
 
228
DROP FUNCTION gbt_int4_same(internal, internal, internal);
 
229
 
 
230
DROP FUNCTION gbt_int4_union(bytea, internal);
 
231
 
 
232
DROP FUNCTION gbt_int4_picksplit(internal, internal);
 
233
 
 
234
DROP FUNCTION gbt_int4_penalty(internal,internal,internal);
 
235
 
 
236
DROP FUNCTION gbt_int4_compress(internal);
 
237
 
 
238
DROP FUNCTION gbt_int4_consistent(internal,int4,int2,oid,internal);
 
239
 
 
240
DROP OPERATOR CLASS gist_int2_ops USING gist;
 
241
 
 
242
DROP FUNCTION gbt_int2_same(internal, internal, internal);
 
243
 
 
244
DROP FUNCTION gbt_int2_union(bytea, internal);
 
245
 
 
246
DROP FUNCTION gbt_int2_picksplit(internal, internal);
 
247
 
 
248
DROP FUNCTION gbt_int2_penalty(internal,internal,internal);
 
249
 
 
250
DROP FUNCTION gbt_int2_compress(internal);
 
251
 
 
252
DROP FUNCTION gbt_int2_consistent(internal,int2,int2,oid,internal);
 
253
 
 
254
DROP OPERATOR CLASS gist_oid_ops USING gist;
 
255
 
 
256
DROP FUNCTION gbt_oid_same(internal, internal, internal);
 
257
 
 
258
DROP FUNCTION gbt_oid_union(bytea, internal);
 
259
 
 
260
DROP FUNCTION gbt_oid_picksplit(internal, internal);
 
261
 
 
262
DROP FUNCTION gbt_oid_penalty(internal,internal,internal);
 
263
 
 
264
DROP FUNCTION gbt_var_decompress(internal);
 
265
 
 
266
DROP FUNCTION gbt_decompress(internal);
 
267
 
 
268
DROP FUNCTION gbt_oid_compress(internal);
 
269
 
 
270
DROP FUNCTION gbt_oid_consistent(internal,oid,int2,oid,internal);
 
271
 
 
272
DROP TYPE gbtreekey_var CASCADE;
 
273
 
 
274
DROP TYPE gbtreekey32 CASCADE;
 
275
 
 
276
DROP TYPE gbtreekey16 CASCADE;
 
277
 
 
278
DROP TYPE gbtreekey8 CASCADE;
 
279
 
 
280
DROP TYPE gbtreekey4 CASCADE;