-
Notifications
You must be signed in to change notification settings - Fork 5
/
wltree--dummy.sql
161 lines (153 loc) · 8.54 KB
/
wltree--dummy.sql
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
/* contrib/wltree/wltree--dummy.sql */
/*
* xxx This version is used to upgrade from version with different name only xxx
* To upgrade from a version with extension name ltree do:
* CREATE EXTENSION wltree VERSION "dummy";
* ALTER EXTENSION wltree UPDATE to "2.0";
*/
-- complain if script is sourced in psql, rather than via CREATE EXTENSION
\echo Use "CREATE EXTENSION ltree" to load this file. \quit
/*
* Bail out if ltree is not installed
*/
DO
$do$
begin
if not exists(select 1 from pg_extension where extname = 'ltree') then
raise exception 'Extension ltree is not installed, there is no need for "dummy" wltree';
end if;
if (select nlevel(ltree'1.2') = 2) then
raise exception 'Installed ltree is the one from contrib module and conflicts with wltree';
end if;
end
$do$;
ALTER EXTENSION ltree DROP type ltree;
ALTER EXTENSION ltree DROP function ltree_in(cstring);
ALTER EXTENSION ltree DROP function ltree_out(ltree);
ALTER EXTENSION ltree DROP function ltree_cmp(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_lt(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_le(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_eq(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_ge(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_gt(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_ne(ltree,ltree);
ALTER EXTENSION ltree DROP operator >(ltree,ltree);
ALTER EXTENSION ltree DROP operator >=(ltree,ltree);
ALTER EXTENSION ltree DROP operator <(ltree,ltree);
ALTER EXTENSION ltree DROP operator <=(ltree,ltree);
ALTER EXTENSION ltree DROP operator <>(ltree,ltree);
ALTER EXTENSION ltree DROP operator =(ltree,ltree);
ALTER EXTENSION ltree DROP function subltree(ltree,integer,integer);
ALTER EXTENSION ltree DROP function subpath(ltree,integer,integer);
ALTER EXTENSION ltree DROP function subpath(ltree,integer);
ALTER EXTENSION ltree DROP function index(ltree,ltree);
ALTER EXTENSION ltree DROP function index(ltree,ltree,integer);
ALTER EXTENSION ltree DROP function nlevel(ltree);
ALTER EXTENSION ltree DROP function ltree2text(ltree);
ALTER EXTENSION ltree DROP function text2ltree(text);
ALTER EXTENSION ltree DROP function lca(ltree[]);
ALTER EXTENSION ltree DROP function lca(ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree,ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree,ltree,ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function lca(ltree,ltree,ltree,ltree,ltree,ltree,ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_isparent(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_risparent(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_addltree(ltree,ltree);
ALTER EXTENSION ltree DROP function ltree_addtext(ltree,text);
ALTER EXTENSION ltree DROP function ltree_textadd(text,ltree);
ALTER EXTENSION ltree DROP function ltreeparentsel(internal,oid,internal,integer);
ALTER EXTENSION ltree DROP operator <@(ltree,ltree);
ALTER EXTENSION ltree DROP operator @>(ltree,ltree);
ALTER EXTENSION ltree DROP operator ^<@(ltree,ltree);
ALTER EXTENSION ltree DROP operator ^@>(ltree,ltree);
ALTER EXTENSION ltree DROP operator ||(ltree,ltree);
ALTER EXTENSION ltree DROP operator ||(ltree,text);
ALTER EXTENSION ltree DROP operator ||(text,ltree);
ALTER EXTENSION ltree DROP operator family ltree_ops using btree;
ALTER EXTENSION ltree DROP operator class ltree_ops using btree;
ALTER EXTENSION ltree DROP type lquery;
ALTER EXTENSION ltree DROP function lquery_in(cstring);
ALTER EXTENSION ltree DROP function lquery_out(lquery);
ALTER EXTENSION ltree DROP function ltq_regex(ltree,lquery);
ALTER EXTENSION ltree DROP function ltq_rregex(lquery,ltree);
ALTER EXTENSION ltree DROP operator ~(lquery,ltree);
ALTER EXTENSION ltree DROP operator ~(ltree,lquery);
ALTER EXTENSION ltree DROP operator ^~(lquery,ltree);
ALTER EXTENSION ltree DROP operator ^~(ltree,lquery);
ALTER EXTENSION ltree DROP function lt_q_regex(ltree,lquery[]);
ALTER EXTENSION ltree DROP function lt_q_rregex(lquery[],ltree);
ALTER EXTENSION ltree DROP operator ?(lquery[],ltree);
ALTER EXTENSION ltree DROP operator ?(ltree,lquery[]);
ALTER EXTENSION ltree DROP operator ^?(lquery[],ltree);
ALTER EXTENSION ltree DROP operator ^?(ltree,lquery[]);
ALTER EXTENSION ltree DROP type ltxtquery;
ALTER EXTENSION ltree DROP function ltxtq_in(cstring);
ALTER EXTENSION ltree DROP function ltxtq_out(ltxtquery);
ALTER EXTENSION ltree DROP function ltxtq_exec(ltree,ltxtquery);
ALTER EXTENSION ltree DROP function ltxtq_rexec(ltxtquery,ltree);
ALTER EXTENSION ltree DROP operator @(ltxtquery,ltree);
ALTER EXTENSION ltree DROP operator @(ltree,ltxtquery);
ALTER EXTENSION ltree DROP operator ^@(ltxtquery,ltree);
ALTER EXTENSION ltree DROP operator ^@(ltree,ltxtquery);
ALTER EXTENSION ltree DROP type ltree_gist;
ALTER EXTENSION ltree DROP function ltree_gist_in(cstring);
ALTER EXTENSION ltree DROP function ltree_gist_out(ltree_gist);
ALTER EXTENSION ltree DROP function ltree_consistent(internal,internal,smallint,oid,internal);
ALTER EXTENSION ltree DROP function ltree_compress(internal);
ALTER EXTENSION ltree DROP function ltree_decompress(internal);
ALTER EXTENSION ltree DROP function ltree_penalty(internal,internal,internal);
ALTER EXTENSION ltree DROP function ltree_picksplit(internal,internal);
ALTER EXTENSION ltree DROP function ltree_union(internal,internal);
ALTER EXTENSION ltree DROP function ltree_same(internal,internal,internal);
ALTER EXTENSION ltree DROP operator family gist_ltree_ops using gist;
ALTER EXTENSION ltree DROP operator class gist_ltree_ops using gist;
ALTER EXTENSION ltree DROP function _ltree_isparent(ltree[],ltree);
ALTER EXTENSION ltree DROP function _ltree_r_isparent(ltree,ltree[]);
ALTER EXTENSION ltree DROP function _ltree_risparent(ltree[],ltree);
ALTER EXTENSION ltree DROP function _ltree_r_risparent(ltree,ltree[]);
ALTER EXTENSION ltree DROP function _ltq_regex(ltree[],lquery);
ALTER EXTENSION ltree DROP function _ltq_rregex(lquery,ltree[]);
ALTER EXTENSION ltree DROP function _lt_q_regex(ltree[],lquery[]);
ALTER EXTENSION ltree DROP function _lt_q_rregex(lquery[],ltree[]);
ALTER EXTENSION ltree DROP function _ltxtq_exec(ltree[],ltxtquery);
ALTER EXTENSION ltree DROP function _ltxtq_rexec(ltxtquery,ltree[]);
ALTER EXTENSION ltree DROP operator <@(ltree,ltree[]);
ALTER EXTENSION ltree DROP operator @>(ltree[],ltree);
ALTER EXTENSION ltree DROP operator @>(ltree,ltree[]);
ALTER EXTENSION ltree DROP operator <@(ltree[],ltree);
ALTER EXTENSION ltree DROP operator ~(lquery,ltree[]);
ALTER EXTENSION ltree DROP operator ~(ltree[],lquery);
ALTER EXTENSION ltree DROP operator ?(lquery[],ltree[]);
ALTER EXTENSION ltree DROP operator ?(ltree[],lquery[]);
ALTER EXTENSION ltree DROP operator @(ltxtquery,ltree[]);
ALTER EXTENSION ltree DROP operator @(ltree[],ltxtquery);
ALTER EXTENSION ltree DROP operator ^<@(ltree,ltree[]);
ALTER EXTENSION ltree DROP operator ^@>(ltree[],ltree);
ALTER EXTENSION ltree DROP operator ^@>(ltree,ltree[]);
ALTER EXTENSION ltree DROP operator ^<@(ltree[],ltree);
ALTER EXTENSION ltree DROP operator ^~(lquery,ltree[]);
ALTER EXTENSION ltree DROP operator ^~(ltree[],lquery);
ALTER EXTENSION ltree DROP operator ^?(lquery[],ltree[]);
ALTER EXTENSION ltree DROP operator ^?(ltree[],lquery[]);
ALTER EXTENSION ltree DROP operator ^@(ltxtquery,ltree[]);
ALTER EXTENSION ltree DROP operator ^@(ltree[],ltxtquery);
ALTER EXTENSION ltree DROP function _ltree_extract_isparent(ltree[],ltree);
ALTER EXTENSION ltree DROP operator ?@>(ltree[],ltree);
ALTER EXTENSION ltree DROP function _ltree_extract_risparent(ltree[],ltree);
ALTER EXTENSION ltree DROP operator ?<@(ltree[],ltree);
ALTER EXTENSION ltree DROP function _ltq_extract_regex(ltree[],lquery);
ALTER EXTENSION ltree DROP operator ?~(ltree[],lquery);
ALTER EXTENSION ltree DROP function _ltxtq_extract_exec(ltree[],ltxtquery);
ALTER EXTENSION ltree DROP operator ?@(ltree[],ltxtquery);
ALTER EXTENSION ltree DROP function _ltree_consistent(internal,internal,smallint,oid,internal);
ALTER EXTENSION ltree DROP function _ltree_compress(internal);
ALTER EXTENSION ltree DROP function _ltree_penalty(internal,internal,internal);
ALTER EXTENSION ltree DROP function _ltree_picksplit(internal,internal);
ALTER EXTENSION ltree DROP function _ltree_union(internal,internal);
ALTER EXTENSION ltree DROP function _ltree_same(internal,internal,internal);
ALTER EXTENSION ltree DROP operator family gist__ltree_ops using gist;
ALTER EXTENSION ltree DROP operator class gist__ltree_ops using gist;
DROP EXTENSION ltree;