2 files changed, 95 insertions, 1 deletions
diff --git a/contrib/cube/Makefile b/contrib/cube/Makefile
index 331b4c9385..e1b9f14244 100644
--- a/contrib/cube/Makefile
+++ b/contrib/cube/Makefile
@@ -1,9 +1,10 @@
-# $PostgreSQL: pgsql/contrib/cube/Makefile,v 1.15 2005/10/18 01:30:48 tgl Exp $
+# $PostgreSQL: pgsql/contrib/cube/Makefile,v 1.16 2006/02/27 12:54:38 petere Exp $
 
 MODULE_big = cube
 OBJS= cube.o cubeparse.o
 
 DATA_built = cube.sql
+DATA = uninstall_cube.sql
 DOCS = README.cube
 REGRESS = cube
 
diff --git a/contrib/cube/uninstall_cube.sql b/contrib/cube/uninstall_cube.sql
new file mode 100644
index 0000000000..a6a177703a
--- /dev/null
+++ b/contrib/cube/uninstall_cube.sql
@@ -0,0 +1,93 @@
+SET search_path = public;
+
+DROP OPERATOR CLASS gist_cube_ops;
+
+DROP OPERATOR CLASS cube_ops;
+
+DROP FUNCTION g_cube_same(cube, cube, internal);
+
+DROP FUNCTION g_cube_union(internal, internal);
+
+DROP FUNCTION g_cube_picksplit(internal, internal);
+
+DROP FUNCTION g_cube_penalty(internal,internal,internal);
+
+DROP FUNCTION g_cube_decompress(internal);
+
+DROP FUNCTION g_cube_compress(internal);
+
+DROP FUNCTION g_cube_consistent(internal,cube,int4);
+
+DROP OPERATOR ~ (cube, cube);
+
+DROP OPERATOR @ (cube, cube);
+
+DROP OPERATOR <> (cube, cube);
+
+DROP OPERATOR = (cube, cube);
+
+DROP OPERATOR && (cube, cube);
+
+DROP OPERATOR >= (cube, cube);
+
+DROP OPERATOR <= (cube, cube);
+
+DROP OPERATOR > (cube, cube);
+
+DROP OPERATOR < (cube, cube);
+
+DROP FUNCTION cube_enlarge(cube, float8, int4);
+
+DROP FUNCTION cube_is_point(cube);
+
+DROP FUNCTION cube(cube, float8, float8);
+
+DROP FUNCTION cube(cube, float8);
+
+DROP FUNCTION cube(float8, float8);
+
+DROP FUNCTION cube(float8);
+
+DROP FUNCTION cube_ur_coord(cube, int4);
+
+DROP FUNCTION cube_ll_coord(cube, int4);
+
+DROP FUNCTION cube_dim(cube);
+
+DROP FUNCTION cube_distance(cube, cube);
+
+DROP FUNCTION cube_size(cube);
+
+DROP FUNCTION cube_inter(cube, cube);
+
+DROP FUNCTION cube_union(cube, cube);
+
+DROP FUNCTION cube_overlap(cube, cube);
+
+DROP FUNCTION cube_contained(cube, cube);
+
+DROP FUNCTION cube_contains(cube, cube);
+
+DROP FUNCTION cube_cmp(cube, cube);
+
+DROP FUNCTION cube_ge(cube, cube);
+
+DROP FUNCTION cube_le(cube, cube);
+
+DROP FUNCTION cube_gt(cube, cube);
+
+DROP FUNCTION cube_lt(cube, cube);
+
+DROP FUNCTION cube_ne(cube, cube);
+
+DROP FUNCTION cube_eq(cube, cube);
+
+DROP CAST (text AS cube);
+
+DROP FUNCTION cube(text);
+
+DROP FUNCTION cube_out(cube);
+
+DROP TYPE cube;
+
+DROP FUNCTION cube_in(cstring);