summaryrefslogtreecommitdiff
path: root/contrib/pg_trgm
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/pg_trgm')
-rw-r--r--contrib/pg_trgm/uninstall_pg_trgm.sql8
1 files changed, 2 insertions, 6 deletions
diff --git a/contrib/pg_trgm/uninstall_pg_trgm.sql b/contrib/pg_trgm/uninstall_pg_trgm.sql
index 1804078f158..8fc85bd7bac 100644
--- a/contrib/pg_trgm/uninstall_pg_trgm.sql
+++ b/contrib/pg_trgm/uninstall_pg_trgm.sql
@@ -2,7 +2,7 @@ SET search_path = public;
BEGIN;
-DROP OPERATOR CLASS gist_trgm_ops;
+DROP OPERATOR CLASS gist_trgm_ops USING gist;
DROP FUNCTION gtrgm_same(gtrgm, gtrgm, internal);
@@ -18,11 +18,7 @@ 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 TYPE gtrgm CASCADE;
DROP OPERATOR % (text, text);