Re: Problem with text search in Postgresql 10

2018-12-18 Thread Tom Lane
Howard News writes: > If I try: > select to_tsquery('english', 'hello'); > I get the error > ERROR:  invalid input syntax for type oid: "english" Huh, should work. What does "\df *.to_tsquery" show? > Any ideas how to fix this? I have read in older support forums that the > problem may be rela

Problem with text search in Postgresql 10

2018-12-18 Thread Howard News
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: