Re: Old tsearch functions

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 tsearch
> functions in my database, and these were copied into the pg_dump that I
> restored into v11 and have caused some confusion and problems.
>
> For example, select to_tsquery('english', 'hello') would not work. The
> reason is the additional functions, domains etc that were added to the
> public schema, probably from the contrib module, which was removed in v10,
>
> Now I can delete all these extra functions and domains and change the
> types of all my tsvector columns from "public.tsvector" to the inbuilt
> type "tsvector", but is there an easier way or a script that exists to
> do this automatically? (I have a lot of databases with this issue)

Is to late to experiment with dropping the extension on a 9.5 database
and then dumping?

>
> Thanks
>
> Howard.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com