Karl Denninger <karl@denninger.net> writes:
> $ more tables_using_reg.txt
> Database: marketticker
> public.pg_ts_dict.dict_init
> public.pg_ts_dict.dict_lexize
> public.pg_ts_parser.prs_start
> public.pg_ts_parser.prs_nexttoken
> public.pg_ts_parser.prs_end
> public.pg_ts_parser.prs_headline
> public.pg_ts_parser.prs_lextype
> Database: ticker
> public.pg_ts_dict.dict_init
> public.pg_ts_dict.dict_lexize
> public.pg_ts_parser.prs_start
> public.pg_ts_parser.prs_nexttoken
> public.pg_ts_parser.prs_end
> public.pg_ts_parser.prs_headline
> public.pg_ts_parser.prs_lextype
> $
Actually you should be able to just drop and forget those tables.
They appear to be carry-forwards from a pre-8.3 installation of
contrib/tsearch2. If so, they don't do anything useful anymore.
(Read the manual's section about migrating from pre-8.3 tsearch.)
> These two databases use the full-text "Tsearch2" module..... I can't
> remove these tables either; they're marked "system" and even as a
> superuser removing them is not permitted.
Possibly you tried to remove the similarly-named system catalogs
(in pg_catalog)?
regards, tom lane