contrib uninstall scripts

by David Fetter

2 files changed, 91 insertions, 1 deletions

diff --git a/contrib/seg/Makefile b/contrib/seg/Makefile
index face0c4177..d40bf42c6e 100644
--- a/contrib/seg/Makefile
+++ b/contrib/seg/Makefile
@@ -1,8 +1,9 @@
-# $PostgreSQL: pgsql/contrib/seg/Makefile,v 1.14 2005/10/18 01:30:48 tgl Exp $
+# $PostgreSQL: pgsql/contrib/seg/Makefile,v 1.15 2006/02/27 12:54:39 petere Exp $
 
 MODULE_big = seg
 OBJS = seg.o segparse.o
 DATA_built = seg.sql
+DATA = uninstall_seg.sql
 DOCS = README.seg
 REGRESS = seg
 
diff --git a/contrib/seg/uninstall_seg.sql b/contrib/seg/uninstall_seg.sql
new file mode 100644
index 0000000000..50e7d24322
--- /dev/null
+++ b/contrib/seg/uninstall_seg.sql
@@ -0,0 +1,89 @@
+SET search_path = public;
+
+DROP OPERATOR CLASS gist_seg_ops;
+
+DROP OPERATOR CLASS seg_ops;
+
+DROP FUNCTION gseg_same(seg, seg, internal);
+
+DROP FUNCTION gseg_union(internal, internal);
+
+DROP FUNCTION gseg_picksplit(internal, internal);
+
+DROP FUNCTION gseg_penalty(internal,internal,internal);
+
+DROP FUNCTION gseg_decompress(internal);
+
+DROP FUNCTION gseg_compress(internal);
+
+DROP FUNCTION gseg_consistent(internal,seg,int4);
+
+DROP OPERATOR ~ (seg, seg);
+
+DROP OPERATOR @ (seg, seg);
+
+DROP OPERATOR <> (seg, seg);
+
+DROP OPERATOR = (seg, seg);
+
+DROP OPERATOR >> (seg, seg);
+
+DROP OPERATOR &> (seg, seg);
+
+DROP OPERATOR && (seg, seg);
+
+DROP OPERATOR &< (seg, seg);
+
+DROP OPERATOR << (seg, seg);
+
+DROP OPERATOR >= (seg, seg);
+
+DROP OPERATOR > (seg, seg);
+
+DROP OPERATOR <= (seg, seg);
+
+DROP OPERATOR < (seg, seg);
+
+DROP FUNCTION seg_lower(seg);
+
+DROP FUNCTION seg_upper(seg);
+
+DROP FUNCTION seg_size(seg);
+
+DROP FUNCTION seg_inter(seg, seg);
+
+DROP FUNCTION seg_union(seg, seg);
+
+DROP FUNCTION seg_cmp(seg, seg);
+
+DROP FUNCTION seg_different(seg, seg);
+
+DROP FUNCTION seg_same(seg, seg);
+
+DROP FUNCTION seg_overlap(seg, seg);
+
+DROP FUNCTION seg_contained(seg, seg);
+
+DROP FUNCTION seg_contains(seg, seg);
+
+DROP FUNCTION seg_ge(seg, seg);
+
+DROP FUNCTION seg_gt(seg, seg);
+
+DROP FUNCTION seg_le(seg, seg);
+
+DROP FUNCTION seg_lt(seg, seg);
+
+DROP FUNCTION seg_right(seg, seg);
+
+DROP FUNCTION seg_left(seg, seg);
+
+DROP FUNCTION seg_over_right(seg, seg);
+
+DROP FUNCTION seg_over_left(seg, seg);
+
+DROP TYPE seg;
+
+DROP FUNCTION seg_out(seg);
+
+DROP FUNCTION seg_in(cstring);