On 30/01/2019 18:08, Tom Lane wrote:
Note that if you had those functions laying around ever since 8.3,
they're probably just "loose" and not wrapped into an extension at all.
You could fix that in a 9.5 database by running
create extension tsearch2 from unpackaged;
which should be enough
On 30/01/2019 17:20, Adrian Klaver wrote:
Is to late to experiment with dropping the extension on a 9.5 database
and then dumping?
Not a problem - The problem only shows in development so far. I have all
the originals in 9.5 and backups to try this on.
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
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