From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Karl Denninger <karl(at)denninger(dot)net> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem with pg_convert from 8.4 -> 9.0 |
Date: | 2010-09-22 04:05:17 |
Message-ID: | 15851.1285128317@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Karl Denninger <karl(at)denninger(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-09-22 04:18:02 | Re: Reclaiming space |
Previous Message | Karl Denninger | 2010-09-22 03:31:10 | Re: Problem with pg_convert from 8.4 -> 9.0 |