-- Clean tsearch tables
DROP TABLE IF EXISTS pg_ts_cfg CASCADE;
DROP TABLE IF EXISTS pg_ts_cfgmap CASCADE;
DROP TABLE IF EXISTS pg_ts_dict CASCADE;
DROP TABLE IF EXISTS pg_ts_parser CASCADE;

-- Clean tsearch functions
DROP FUNCTION IF EXISTS concat(tsvector, tsvector) CASCADE;
DROP FUNCTION IF EXISTS dex_init(internal) CASCADE;
DROP FUNCTION IF EXISTS dex_lexize(internal, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS exectsq(tsvector, tsquery) CASCADE;
DROP FUNCTION IF EXISTS get_covers(tsvector, tsquery) CASCADE;
DROP FUNCTION IF EXISTS _get_parser_from_curcfg() CASCADE;
DROP FUNCTION IF EXISTS gtsvector_compress(internal) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_consistent(gtsvector, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_decompress(internal) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_in(cstring) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_out(gtsvector) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_penalty(internal, internal, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_picksplit(internal, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_same(gtsvector, gtsvector, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsvector_union(internal, internal) CASCADE;
DROP FUNCTION IF EXISTS headline(oid, text, tsquery) CASCADE;
DROP FUNCTION IF EXISTS headline(oid, text, tsquery, text) CASCADE;
DROP FUNCTION IF EXISTS headline(text, text, tsquery) CASCADE;
DROP FUNCTION IF EXISTS headline(text, text, tsquery, text) CASCADE;
DROP FUNCTION IF EXISTS headline(text, tsquery) CASCADE;
DROP FUNCTION IF EXISTS headline(text, tsquery, text) CASCADE;
DROP FUNCTION IF EXISTS length(tsvector) CASCADE;
DROP FUNCTION IF EXISTS lexize(oid, text) CASCADE;
DROP FUNCTION IF EXISTS lexize(text) CASCADE;
DROP FUNCTION IF EXISTS lexize(text, text) CASCADE;
DROP FUNCTION IF EXISTS parse(oid, text) CASCADE;
DROP FUNCTION IF EXISTS parse(text) CASCADE;
DROP FUNCTION IF EXISTS parse(text, text) CASCADE;
DROP FUNCTION IF EXISTS prsd_end(internal) CASCADE;
DROP FUNCTION IF EXISTS prsd_getlexeme(internal, internal, internal) CASCADE;
DROP FUNCTION IF EXISTS prsd_headline(internal, internal, internal) CASCADE;
DROP FUNCTION IF EXISTS prsd_lextype(internal) CASCADE;
DROP FUNCTION IF EXISTS prsd_start(internal, integer) CASCADE;
DROP FUNCTION IF EXISTS querytree(tsquery) CASCADE;
-- DROP FUNCTION IF EXISTS rank_cd(integer, tsvector, tsquery) CASCADE;
-- DROP FUNCTION IF EXISTS rank_cd(integer, tsvector, tsquery, integer) CASCADE;
DROP FUNCTION IF EXISTS rank_cd(tsvector, tsquery) CASCADE;
DROP FUNCTION IF EXISTS rank_cd(tsvector, tsquery, integer) CASCADE;
DROP FUNCTION IF EXISTS rank(real[], tsvector, tsquery) CASCADE;
DROP FUNCTION IF EXISTS rank(real[], tsvector, tsquery, integer) CASCADE;
DROP FUNCTION IF EXISTS rank(tsvector, tsquery) CASCADE;
DROP FUNCTION IF EXISTS rank(tsvector, tsquery, integer) CASCADE;
DROP FUNCTION IF EXISTS reset_tsearch() CASCADE;
DROP FUNCTION IF EXISTS rexectsq(tsquery, tsvector) CASCADE;
DROP FUNCTION IF EXISTS set_curcfg(integer) CASCADE;
DROP FUNCTION IF EXISTS set_curcfg(text) CASCADE;
DROP FUNCTION IF EXISTS set_curdict(integer) CASCADE;
DROP FUNCTION IF EXISTS set_curdict(text) CASCADE;
DROP FUNCTION IF EXISTS set_curprs(integer) CASCADE;
DROP FUNCTION IF EXISTS set_curprs(text) CASCADE;
DROP FUNCTION IF EXISTS setweight(tsvector, "char") CASCADE;
DROP FUNCTION IF EXISTS show_curcfg() CASCADE;
DROP FUNCTION IF EXISTS snb_en_init(internal) CASCADE;
DROP FUNCTION IF EXISTS snb_lexize(internal, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS snb_ru_init_koi8(internal) CASCADE;
DROP FUNCTION IF EXISTS snb_ru_init_utf8(internal) CASCADE;
DROP FUNCTION IF EXISTS spell_init(internal) CASCADE;
DROP FUNCTION IF EXISTS spell_lexize(internal, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS stat(text) CASCADE;
DROP FUNCTION IF EXISTS stat(text, text) CASCADE;
DROP FUNCTION IF EXISTS "strip"(tsvector) CASCADE;
DROP FUNCTION IF EXISTS syn_init(internal) CASCADE;
DROP FUNCTION IF EXISTS syn_lexize(internal, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS token_type() CASCADE;
DROP FUNCTION IF EXISTS token_type(integer) CASCADE;
DROP FUNCTION IF EXISTS token_type(text) CASCADE;
DROP FUNCTION IF EXISTS to_tsquery(oid, text) CASCADE;
DROP FUNCTION IF EXISTS to_tsquery(text) CASCADE;
DROP FUNCTION IF EXISTS to_tsquery(text, text) CASCADE;
DROP FUNCTION IF EXISTS to_tsvector(oid, text) CASCADE;
DROP FUNCTION IF EXISTS to_tsvector(text) CASCADE;
DROP FUNCTION IF EXISTS to_tsvector(text, text) CASCADE;
DROP FUNCTION IF EXISTS ts_debug(text) CASCADE;
DROP FUNCTION IF EXISTS tsearch2() CASCADE;
DROP FUNCTION IF EXISTS tsquery_in(cstring) CASCADE;
-- DROP FUNCTION IF EXISTS tsquery_out(tsquery) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_cmp(tsvector, tsvector) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_eq(tsvector, tsvector) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_ge(tsvector, tsvector) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_gt(tsvector, tsvector) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_in(cstring) CASCADE;
-- DROP FUNCTION IF EXISTS tsvector_le(tsvector, tsvector) CASCADE;
DROP FUNCTION IF EXISTS tsvector_lt(tsvector, tsvector) CASCADE;
DROP FUNCTION IF EXISTS tsvector_ne(tsvector, tsvector) CASCADE;
DROP FUNCTION IF EXISTS tsvector_out(tsvector) CASCADE;



DROP TABLE IF EXISTS fticols CASCADE;

DROP FUNCTION IF EXISTS gtsq_compress(internal) CASCADE;
DROP FUNCTION IF EXISTS gtsq_consistent(gtsq, internal, integer) CASCADE;
DROP FUNCTION IF EXISTS gtsq_decompress(internal) CASCADE;
-- DROP FUNCTION IF EXISTS gtsq_in(cstring) CASCADE;
DROP FUNCTION IF EXISTS gtsq_out(gtsq) CASCADE;
DROP FUNCTION IF EXISTS gtsq_penalty(internal, internal, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsq_picksplit(internal, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsq_same(gtsq, gtsq, internal) CASCADE;
DROP FUNCTION IF EXISTS gtsq_union(bytea, internal) CASCADE;

DROP FUNCTION IF EXISTS thesaurus_init(internal) CASCADE;
DROP FUNCTION IF EXISTS thesaurus_lexize(internal, internal, integer, internal) CASCADE;
DROP FUNCTION IF EXISTS isfti(text) CASCADE;
DROP FUNCTION IF EXISTS restore_fti() CASCADE;
DROP FUNCTION IF EXISTS fti_addcolumn(text) CASCADE;
DROP FUNCTION IF EXISTS fti_dropcolumn(text) CASCADE;
DROP FUNCTION IF EXISTS fti_show() CASCADE;

DROP FUNCTION IF EXISTS tsearch2() CASCADE;