Karl Denninger <k...@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

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to