Re: Is dropping pg_ts_* harmful?

On Mon, Feb 02, 2009 at 09:40:16AM -0500, Eric Brown wrote:
> I have a database running very happily in 8.2 (to be upgraded soon).
> The system was installed with tsearch2 enabled, however, we have yet
> to use it. I am going through an effort to reduce "cruft" in the
> database, which includes four tables: pg_ts_cfg, pg_ts_cfgmap,
> pg_ts_dict, pg_ts_parser. Are these tables safe to drop? Will the
> remnants of tsearch2 be anywhere else in the database if it was
> never used?
>

There should be an uninstall_tsearch2.sql script somewhere on your
system if you have a relatively recent 8.2. That should scrub
everything :)

Cheers,
David.
> Thanks folks --
>
> -- Eric Brown / Director of IT / www.mediweightlossclinics.com

--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate