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, 5 insertions, 18 deletions

diff --git a/contrib/chkpass/uninstall_chkpass.sql b/contrib/chkpass/uninstall_chkpass.sql
index f1f8574bcc..4a4737a1d5 100644
--- a/contrib/chkpass/uninstall_chkpass.sql
+++ b/contrib/chkpass/uninstall_chkpass.sql
@@ -1,19 +1,10 @@
 SET search_path = public;
 
-DROP OPERATOR <>; (
-	leftarg = chkpass,
-	rightarg = text,
-	negator = =,
-	procedure = ne
-);
+DROP OPERATOR <>(chkpass, text);
 
-DROP OPERATOR =; (
-	leftarg = chkpass,
-	rightarg = text,
-	commutator = =,
---	negator = <>,
-	procedure = eq
-);
+DROP OPERATOR =(chkpass, text);
+
+DROP OPERATOR =(text, chkpass);
 
 DROP FUNCTION ne(chkpass, text);
 
@@ -21,8 +12,4 @@ DROP FUNCTION eq(chkpass, text);
 
 DROP FUNCTION raw(chkpass);
 
-DROP TYPE chkpass;
-
-DROP FUNCTION chkpass_out(chkpass);
-
-DROP FUNCTION chkpass_in(cstring);
+DROP TYPE chkpass CASCADE;