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

From rkmr.em@gmail.com
Subject uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
Date
Msg-id e04d2e90802191638l67e0e963l3f40e34d4697ded3@mail.gmail.com
Whole thread Raw
Responses Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
List pgsql-general
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Analogue to SQL Server UniqueIdentifier?
Next
From: Tom Lane
Date:
Subject: Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"