contrib uninstall scripts

by David Fetter

2 files changed, 40 insertions, 0 deletions

diff --git a/contrib/pg_trgm/Makefile b/contrib/pg_trgm/Makefile
index 993089151a4..36714409c3b 100644
--- a/contrib/pg_trgm/Makefile
+++ b/contrib/pg_trgm/Makefile
@@ -5,6 +5,7 @@ MODULE_big = pg_trgm
 OBJS = trgm_op.o trgm_gist.o 
 
 DATA_built = pg_trgm.sql
+DATA = uninstall_pg_trgm.sql
 DOCS = README.pg_trgm
 REGRESS = pg_trgm
 
diff --git a/contrib/pg_trgm/uninstall_pg_trgm.sql b/contrib/pg_trgm/uninstall_pg_trgm.sql
new file mode 100644
index 00000000000..1804078f158
--- /dev/null
+++ b/contrib/pg_trgm/uninstall_pg_trgm.sql
@@ -0,0 +1,39 @@
+SET search_path = public;
+
+BEGIN;
+
+DROP OPERATOR CLASS gist_trgm_ops;
+
+DROP FUNCTION gtrgm_same(gtrgm, gtrgm, internal);
+
+DROP FUNCTION gtrgm_union(bytea, internal);
+
+DROP FUNCTION gtrgm_picksplit(internal, internal);
+
+DROP FUNCTION gtrgm_penalty(internal,internal,internal);
+
+DROP FUNCTION gtrgm_decompress(internal);
+
+DROP FUNCTION gtrgm_compress(internal);
+ 
+DROP FUNCTION gtrgm_consistent(gtrgm,internal,int4);
+
+DROP TYPE gtrgm;
+
+DROP FUNCTION gtrgm_out(gtrgm);
+
+DROP FUNCTION gtrgm_in(cstring);
+
+DROP OPERATOR % (text, text);
+
+DROP FUNCTION similarity_op(text,text);
+
+DROP FUNCTION similarity(text,text);
+
+DROP FUNCTION show_trgm(text);
+
+DROP FUNCTION show_limit();
+
+DROP FUNCTION set_limit(float4);
+
+COMMIT;