Re: text search configuration missing while migration from 8.3 to 9.4

Поиск
Список
Период
Сортировка
От Julie Nishimura
Тема Re: text search configuration missing while migration from 8.3 to 9.4
Дата
Msg-id BYAPR08MB5014EAB6A5FD9BE30980C275AC250@BYAPR08MB5014.namprd08.prod.outlook.com
обсуждение исходный текст
Ответ на Re: text search configuration missing while migration from 8.3 to 9.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: text search configuration missing while migration from 8.3 to 9.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: text search configuration missing while migration from 8.3 to 9.4  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Thank you. Is there a way to find out if I have tables with tsvectors or indexes? I have hundreds of tables...

From: Tom Lane <tgl@sss.pgh.pa.us>
Sent: Tuesday, April 16, 2019 9:45 PM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-general@lists.postgresql.org
Subject: Re: text search configuration missing while migration from 8.3 to 9.4
 
Julie Nishimura <juliezain@hotmail.com> writes:
> Thank you guys. I've dumped the schema and was able to load it properly this time. There were some missing text search dictionaries, fts templates and functions. I was able to recreate it. Now is my question - do I need to reload the data?

The base textual data should be fine, but if you've got derived
tsvector columns or indexes, you might need to recompute those.

                        regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: text search configuration missing while migration from 8.3 to 9.4
Следующее
От: Zahir Lalani
Дата:
Сообщение: RE: Possible corrupt index?