Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
Date: 2008-02-20 08:38:26
Message-ID: 20080220083826.GB17768@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Feb 19, 2008 at 07:58:20PM -0500, Tom Lane wrote:
> "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas 2008-02-20 08:51:31 Re: Using sequences in SQL text files
Previous Message HHB 2008-02-20 07:57:03 Re: Using sequences in SQL text files