Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin" - Mailing list pgsql-general

From Magnus Hagander
Subject Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
Date
Msg-id 20080220083826.GB17768@svr2.hagander.net
Whole thread Raw
In response to Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Tue, Feb 19, 2008 at 07:58:20PM -0500, Tom Lane wrote:
> "rkmr.em@gmail.com" <rkmr.em@gmail.com> writes:
> > when i try to uninstall tsearch2 i get this error,
>
> Hmm, maybe you originally put tsearch2 into some other schema than
> "public"?  If so, try setting search_path to point to that schema
> before you run the uninstall script.

Or it could be the opposite situation. The tsearch2 install-script in 8.2
is hardcoded to always put things in the public schema even if you try to
put them elsewhere (you have to edit the script to get it where you want),
but the uninstall script is not hardcoded. So if there's a different
default schema, it will be installed in public but attempt to delete it
frmo the other schema.

//Magnus

pgsql-general by date:

Previous
From: HHB
Date:
Subject: Re: Using sequences in SQL text files
Next
From: Thomas
Date:
Subject: Re: Using sequences in SQL text files