Re: Problems Upgrading from 8.2 to 9.0

Поиск
Список
Период
Сортировка
От Adib
Тема Re: Problems Upgrading from 8.2 to 9.0
Дата
Msg-id AANLkTi=tOebJxZKZeFKngAzDiZhG3FC1vRiiDVCvE+nz@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Problems Upgrading from 8.2 to 9.0  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Ответы Re: Problems Upgrading from 8.2 to 9.0  (Adib <amslist@gmail.com>)
Список pgsql-admin
Is there some way to avoid restoring tsearch2 since full text searching is now part of postgres 9.0, the apps that use the database don't do any full text searching.



2010/12/21 Devrim GÜNDÜZ <devrim@gunduz.org>
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
> ERROR:  type "tsvector" is only a shell
> ERROR:  operator class "gin_tsvector_ops" does not exist for access
> method
> "gin

*IIRC*, you need to load contrib/tsearch2.sql to database *before*
restoring your backup.

Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

В списке pgsql-admin по дате отправления:

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: Problems Upgrading from 8.2 to 9.0
Следующее
От: kubus__puchatek@tlen.pl
Дата:
Сообщение: how made procedure returned different types of value?