Problem with text search in Postgresql 10

From: Howard News <howardnews(at)selestial(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Problem with text search in Postgresql 10
Date: 2018-12-18 16:59:29
Message-ID: 094c0bc5-12af-90c7-8dab-d181efec3149@selestial.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi everyone,

a colleague has restored a backup from an older version of Postgres
(unknown) to version 10. Everything appears to be working fine with the
exception of the text search.

If I try:

select to_tsquery('english', 'hello');

I get the error

ERROR:  invalid input syntax for type oid: "english"
LINE 1: select to_tsquery('english','Hello');

I can see from \dF that I have 'pg_catalog.english' installed. It works
if I do not specify the dictionary using:

select to_tsquery('hello');

Any ideas how to fix this? I have read in older support forums that the
problem may be related to older contrib methods for ts_query. If this is
so - how do I remove the contrib decalrations?

Thanks

Howard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2018-12-18 17:53:15 Re: Problem with text search in Postgresql 10
Previous Message Ron 2018-12-18 16:40:19 Re: Format an Update with calculation