aboutsummaryrefslogtreecommitdiff
path: root/contrib/intarray
diff options
context:
space:
mode:
authorPeter Eisentraut <peter_e@gmx.net>2006-02-27 12:54:39 +0000
committerPeter Eisentraut <peter_e@gmx.net>2006-02-27 12:54:39 +0000
commitfe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (patch)
tree33659142c317fc19ac4db5d70e8883e47a0c7821 /contrib/intarray
parentd46fbef386b88d062bb0b00f17cbcf97f58ec821 (diff)
downloadpostgresql-fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c.tar.gz
postgresql-fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c.zip
contrib uninstall scripts
by David Fetter
Diffstat (limited to 'contrib/intarray')
-rw-r--r--contrib/intarray/Makefile3
-rw-r--r--contrib/intarray/uninstall__int.sql123
2 files changed, 125 insertions, 1 deletions
diff --git a/contrib/intarray/Makefile b/contrib/intarray/Makefile
index 17714b24cbc..b3830a2dde0 100644
--- a/contrib/intarray/Makefile
+++ b/contrib/intarray/Makefile
@@ -1,8 +1,9 @@
-# $PostgreSQL: pgsql/contrib/intarray/Makefile,v 1.12 2005/09/27 17:13:04 tgl Exp $
+# $PostgreSQL: pgsql/contrib/intarray/Makefile,v 1.13 2006/02/27 12:54:39 petere Exp $
MODULE_big = _int
OBJS = _int_bool.o _int_gist.o _int_op.o _int_tool.o _intbig_gist.o
DATA_built = _int.sql
+DATA = uninstall__int.sql
DOCS = README.intarray
REGRESS = _int
diff --git a/contrib/intarray/uninstall__int.sql b/contrib/intarray/uninstall__int.sql
new file mode 100644
index 00000000000..92dc92aeae5
--- /dev/null
+++ b/contrib/intarray/uninstall__int.sql
@@ -0,0 +1,123 @@
+SET search_path = public;
+
+DROP OPERATOR CLASS gist__intbig_ops;
+
+DROP FUNCTION g_intbig_same(internal, internal, internal);
+
+DROP FUNCTION g_intbig_union(internal, internal);
+
+DROP FUNCTION g_intbig_picksplit(internal, internal);
+
+DROP FUNCTION g_intbig_penalty(internal,internal,internal);
+
+DROP FUNCTION g_intbig_decompress(internal);
+
+DROP FUNCTION g_intbig_compress(internal);
+
+DROP FUNCTION g_intbig_consistent(internal,internal,int4);
+
+DROP TYPE intbig_gkey;
+
+DROP FUNCTION _intbig_out(intbig_gkey);
+
+DROP FUNCTION _intbig_in(cstring);
+
+DROP OPERATOR CLASS gist__int_ops;
+
+DROP FUNCTION g_int_same(_int4, _int4, internal);
+
+DROP FUNCTION g_int_union(internal, internal);
+
+DROP FUNCTION g_int_picksplit(internal, internal);
+
+DROP FUNCTION g_int_penalty(internal,internal,internal);
+
+DROP FUNCTION g_int_decompress(internal);
+
+DROP FUNCTION g_int_compress(internal);
+
+DROP FUNCTION g_int_consistent(internal,_int4,int4);
+
+DROP OPERATOR & (_int4, _int4);
+
+DROP OPERATOR - (_int4, _int4);
+
+DROP FUNCTION intset_subtract(_int4, _int4);
+
+DROP OPERATOR | (_int4, _int4);
+
+DROP OPERATOR | (_int4, int4);
+
+DROP FUNCTION intset_union_elem(_int4, int4);
+
+DROP OPERATOR - (_int4, int4);
+
+DROP FUNCTION intarray_del_elem(_int4, int4);
+
+DROP OPERATOR + (_int4, _int4);
+
+DROP FUNCTION intarray_push_array(_int4, _int4);
+
+DROP OPERATOR + (_int4, int4);
+
+DROP FUNCTION intarray_push_elem(_int4, int4);
+
+DROP FUNCTION subarray(_int4, int4);
+
+DROP FUNCTION subarray(_int4, int4, int4);
+
+DROP OPERATOR # (_int4, int4);
+
+DROP FUNCTION idx(_int4, int4);
+
+DROP FUNCTION uniq(_int4);
+
+DROP FUNCTION sort_desc(_int4);
+
+DROP FUNCTION sort_asc(_int4);
+
+DROP FUNCTION sort(_int4);
+
+DROP FUNCTION sort(_int4, text);
+
+DROP OPERATOR # (NONE, _int4);
+
+DROP FUNCTION icount(_int4);
+
+DROP FUNCTION intset(int4);
+
+DROP OPERATOR ~ (_int4, _int4);
+
+DROP OPERATOR @ (_int4, _int4);
+
+DROP OPERATOR && (_int4, _int4);
+
+DROP FUNCTION _int_inter(_int4, _int4);
+
+DROP FUNCTION _int_union(_int4, _int4);
+
+DROP FUNCTION _int_different(_int4, _int4);
+
+DROP FUNCTION _int_same(_int4, _int4);
+
+DROP FUNCTION _int_overlap(_int4, _int4);
+
+DROP FUNCTION _int_contained(_int4, _int4);
+
+DROP FUNCTION _int_contains(_int4, _int4);
+
+DROP OPERATOR ~~ (query_int, _int4);
+
+DROP OPERATOR @@ (_int4, query_int);
+
+DROP FUNCTION rboolop(query_int, _int4);
+
+DROP FUNCTION boolop(_int4, query_int);
+
+DROP FUNCTION querytree(query_int);
+
+DROP TYPE query_int;
+
+DROP FUNCTION bqarr_out(query_int);
+
+DROP FUNCTION bqarr_in(cstring);