Обсуждение: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"

hi
when i try to uninstall tsearch2 i get this error,
my postgres version is 8.2.5
how to fix this?
thanks a lot!



/usr/local/pgsql/bin/psql -U postgres -h localhost -f
/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql
BEGIN
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:8: ERROR:
operator class "gin_tsvector_ops" does not exist for access method
"gin"
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:10: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:13: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:14: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:15: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:19: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:20: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:21: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:22: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:24: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:25: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:26: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:27: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:28: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:30: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:31: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:32: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:34: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:35: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:36: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:37: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:38: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:39: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:40: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:41: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:42: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:43: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:44: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:45: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:46: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:47: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:48: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:49: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:50: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:51: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:52: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:53: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:54: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:55: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:56: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:57: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:58: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:59: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:60: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:61: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:62: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:63: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:64: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:65: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:66: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:67: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:68: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:69: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:70: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:71: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:72: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
psql:/usr/local/pgsql/share/contrib/uninstall_tsearch2.sql:73: ERROR:
current transaction is aborted, commands ignored until end of
transaction block
ROLLBACK

"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.

For that matter, are you sure tsearch2 actually is installed in
this database?  The behavior you show is indistinguishable from
what would happen if it isn't.

            regards, tom lane

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