From fe83b3ebc6b8d65fbb14100bdc476b7dbc32454c Mon Sep 17 00:00:00 2001
From: Peter Eisentraut <peter_e@gmx.net>
Date: Mon, 27 Feb 2006 12:54:39 +0000
Subject: contrib uninstall scripts

by David Fetter
---
 contrib/chkpass/Makefile              |  3 ++-
 contrib/chkpass/uninstall_chkpass.sql | 28 ++++++++++++++++++++++++++++
 2 files changed, 30 insertions(+), 1 deletion(-)
 create mode 100644 contrib/chkpass/uninstall_chkpass.sql

(limited to 'contrib/chkpass')

diff --git a/contrib/chkpass/Makefile b/contrib/chkpass/Makefile
index a9e8f2d91e..af7f492b3a 100644
--- a/contrib/chkpass/Makefile
+++ b/contrib/chkpass/Makefile
@@ -1,9 +1,10 @@
-# $PostgreSQL: pgsql/contrib/chkpass/Makefile,v 1.7 2005/09/27 17:13:00 tgl Exp $
+# $PostgreSQL: pgsql/contrib/chkpass/Makefile,v 1.8 2006/02/27 12:54:38 petere Exp $
 
 MODULE_big = chkpass
 OBJS = chkpass.o
 SHLIB_LINK = $(filter -lcrypt, $(LIBS))
 DATA_built = chkpass.sql
+DATA = uninstall_chkpass.sql
 DOCS = README.chkpass
 
 ifdef USE_PGXS
diff --git a/contrib/chkpass/uninstall_chkpass.sql b/contrib/chkpass/uninstall_chkpass.sql
new file mode 100644
index 0000000000..f1f8574bcc
--- /dev/null
+++ b/contrib/chkpass/uninstall_chkpass.sql
@@ -0,0 +1,28 @@
+SET search_path = public;
+
+DROP OPERATOR <>; (
+	leftarg = chkpass,
+	rightarg = text,
+	negator = =,
+	procedure = ne
+);
+
+DROP OPERATOR =; (
+	leftarg = chkpass,
+	rightarg = text,
+	commutator = =,
+--	negator = <>,
+	procedure = eq
+);
+
+DROP FUNCTION ne(chkpass, text);
+
+DROP FUNCTION eq(chkpass, text);
+
+DROP FUNCTION raw(chkpass);
+
+DROP TYPE chkpass;
+
+DROP FUNCTION chkpass_out(chkpass);
+
+DROP FUNCTION chkpass_in(cstring);
-- 
cgit v1.2.1