On 4/16/19 10:51 PM, Julie Nishimura wrote:
Thank you. Is there a way to find out if I have tables with tsvectors or
indexes? I have hundreds of tables...
I'm afraid I know the answers, but I will ask anyway:
Is there any documentation to go along with the database?
Or, is the schema in some form of version control that you can search?
------------------------------------------------------------------------
*From:* Tom Lane <tgl@xxxxxxxxxxxxx>
*Sent:* Tuesday, April 16, 2019 9:45 PM
*To:* Julie Nishimura
*Cc:* Adrian Klaver; pgsql-general@xxxxxxxxxxxxxxxxxxxx
*Subject:* Re: text search configuration missing while migration from
8.3 to 9.4
Julie Nishimura <juliezain@xxxxxxxxxxx> 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
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
