Fix a number of syntax errors in contrib modules' uninstall scripts.

Most of the changes add the mandatory USING clause to DROP OPERATOR
CLASS statements.  DROP TYPE is now DROP TYPE CASCADE; without
CASCADE a DROP TYPE fails due to the circular dependency on the
type's I/O functions.  The DROP FUNCTION statements for the I/O
functions have been removed, as DROP TYPE CASCADE removes them
automatically. Patch from Michael Fuhr.

1 files changed, 3 insertions, 7 deletions

diff --git a/contrib/cube/uninstall_cube.sql b/contrib/cube/uninstall_cube.sql
index a6a177703a..6ae8ee15cc 100644
--- a/contrib/cube/uninstall_cube.sql
+++ b/contrib/cube/uninstall_cube.sql
@@ -1,8 +1,8 @@
 SET search_path = public;
 
-DROP OPERATOR CLASS gist_cube_ops;
+DROP OPERATOR CLASS gist_cube_ops USING gist;
 
-DROP OPERATOR CLASS cube_ops;
+DROP OPERATOR CLASS cube_ops USING btree;
 
 DROP FUNCTION g_cube_same(cube, cube, internal);
 
@@ -86,8 +86,4 @@ DROP CAST (text AS cube);
 
 DROP FUNCTION cube(text);
 
-DROP FUNCTION cube_out(cube);
-
-DROP TYPE cube;
-
-DROP FUNCTION cube_in(cstring);
+DROP TYPE cube CASCADE;