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 <t...@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 <juliez...@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