Old tsearch functions

From: Howard News <howardnews(at)selestial(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Old tsearch functions
Date: 2019-01-30 17:07:37
Message-ID: 077abc5d-0ffe-5a54-38b3-a36cbcaeec48@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

Thanks

Howard.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-01-30 17:20:17 Re: Old tsearch functions
Previous Message Adrian Klaver 2019-01-30 15:29:07 Re: Major upgrade from 9.6.10 to 10.6 and pg_stat_statement update