diff options
author | Peter Eisentraut <peter_e@gmx.net> | 2006-02-27 12:54:39 +0000 |
---|---|---|
committer | Peter Eisentraut <peter_e@gmx.net> | 2006-02-27 12:54:39 +0000 |
commit | fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c (patch) | |
tree | 33659142c317fc19ac4db5d70e8883e47a0c7821 /contrib/intarray | |
parent | d46fbef386b88d062bb0b00f17cbcf97f58ec821 (diff) | |
download | postgresql-fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c.tar.gz postgresql-fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c.zip |
contrib uninstall scripts
by David Fetter
Diffstat (limited to 'contrib/intarray')
-rw-r--r-- | contrib/intarray/Makefile | 3 | ||||
-rw-r--r-- | contrib/intarray/uninstall__int.sql | 123 |
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); |