| From: | Julie Nishimura <juliezain(at)hotmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: text search configuration missing while migration from 8.3 to 9.4 |
| Date: | 2019-04-17 05:51:07 |
| Message-ID: | BYAPR08MB5014EAB6A5FD9BE30980C275AC250@BYAPR08MB5014.namprd08.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)sss(dot)pgh(dot)pa(dot)us>
Sent: Tuesday, April 16, 2019 9:45 PM
To: Julie Nishimura
Cc: Adrian Klaver; pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: text search configuration missing while migration from 8.3 to 9.4
Julie Nishimura <juliezain(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zahir Lalani | 2019-04-17 07:42:55 | RE: Possible corrupt index? |
| Previous Message | Tom Lane | 2019-04-17 04:45:41 | Re: text search configuration missing while migration from 8.3 to 9.4 |