Re: Old tsearch functions

2019-01-31 Thread Howard News
On 31/01/2019 14:58, Tom Lane wrote: Howard News writes: On 30/01/2019 18:08, Tom Lane wrote: Note that if you had those functions laying around ever since 8.3, they're probably just "loose" and not wrapped into an extension at all. unfortunately running create extension tsearch2 from unpac

Re: Old tsearch functions

2019-01-31 Thread Tom Lane
Howard News writes: > On 30/01/2019 18:08, Tom Lane wrote: >> Note that if you had those functions laying around ever since 8.3, >> they're probably just "loose" and not wrapped into an extension at all. > unfortunately running > create extension tsearch2 from unpackaged; > caused the following e

Re: Old tsearch functions

2019-01-31 Thread Howard News
On 30/01/2019 18:08, Tom Lane wrote: Note that if you had those functions laying around ever since 8.3, they're probably just "loose" and not wrapped into an extension at all. You could fix that in a 9.5 database by running create extension tsearch2 from unpackaged; which should be enough to

Re: Old tsearch functions

2019-01-30 Thread Tom Lane
Howard News writes: > On 30/01/2019 17:20, Adrian Klaver wrote: >> Is to late to experiment with dropping the extension on a 9.5 database >> and then dumping? > Not a problem - The problem only shows in development so far. I have all > the originals in 9.5 and backups to try this on. Note that

Re: Old tsearch functions

2019-01-30 Thread Howard News
On 30/01/2019 17:20, Adrian Klaver wrote: Is to late to experiment with dropping the extension on a 9.5 database and then dumping? Not a problem - The problem only shows in development so far. I have all the originals in 9.5 and backups to try this on.

Re: Old tsearch functions

2019-01-30 Thread Adrian Klaver
On 1/30/19 9:07 AM, Howard News wrote: Hi, upgrading from 9.5 to 11.1, I have a few tsearch problems that appear to relate to a much older migration (8.3) Originally, for those that remember that far back, tsearch was a contrib module. However it appears that I still have some of the old tse