uninstall_pg_trgm.sql 1.1 KB
Newer Older
1
/* $PostgreSQL: pgsql/contrib/pg_trgm/uninstall_pg_trgm.sql,v 1.7 2009/03/25 22:19:01 tgl Exp $ */
2

3
-- Adjust this setting to control where the objects get dropped.
P
Peter Eisentraut 已提交
4 5
SET search_path = public;

6
DROP OPERATOR CLASS gist_trgm_ops USING gist;
P
Peter Eisentraut 已提交
7 8 9 10 11 12 13 14 15 16 17 18 19

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);
 
20
DROP FUNCTION gtrgm_consistent(internal,text,int,oid,internal);
P
Peter Eisentraut 已提交
21

22
DROP TYPE gtrgm CASCADE;
P
Peter Eisentraut 已提交
23

24 25 26 27
DROP OPERATOR CLASS gin_trgm_ops USING gin;

DROP FUNCTION gin_extract_trgm(text, internal);

28
DROP FUNCTION gin_extract_trgm(text, internal, int2, internal, internal);
29

30
DROP FUNCTION gin_trgm_consistent(internal, int2, text, int4, internal, internal);
31

P
Peter Eisentraut 已提交
32 33 34 35 36 37 38 39 40 41 42
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);