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

From: "rkmr(dot)em(at)gmail(dot)com" <rkmr(dot)em(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
Date: 2008-02-20 00:38:03
Message-ID: e04d2e90802191638l67e0e963l3f40e34d4697ded3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-20 00:58:20 Re: uninstalling tsearch2 error: "gin_tsvector_ops" does not exist for access method "gin"
Previous Message Alvaro Herrera 2008-02-19 21:34:57 Re: Analogue to SQL Server UniqueIdentifier?