Old tsearch functions

[Howard News <howardnews@xxxxxxxxxxxxx>]

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.