[NOVICE] Fwd: tsearch2 in Postgres 9.5 - Mailing list pgsql-novice

From Anrik Drenth
Subject [NOVICE] Fwd: tsearch2 in Postgres 9.5
Date
Msg-id CAEdS=woDQ_N0ahv_-tqxp+hDfawx1LRmbcVY6azLpjRwahiN0w@mail.gmail.com
Whole thread Raw
Responses Re: [NOVICE] Fwd: tsearch2 in Postgres 9.5
List pgsql-novice
Hi,

I'm trying to migrate a Postgres database from 8.3 to 9.5.  The database uses tsearch functionality.

The extensions tsearch2--1.0.sql and tsearch2--unpackaged--1.0.sql, found in /usr/share/postgresql/9.5/extension, have been loaded.  This took care of most of the error messages when loading the database.

However 3 error messages persist:
ERROR: function gin_extract_tsquery(pg_catalog.tsquery, internal, smallint) does not exist
ERROR: function gtsquery_consistent(bigint, internal, integer) does not exist
ERROR: function gtsvector_consistent(pg_catalog.gtsvector, internal, integer) does not exist

I'm struggling to find an answer how to resolve the error messages. Any assistance greatly appreciated. 

Thanks

pgsql-novice by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [NOVICE] Adding SSD to HDD-based System
Next
From: Tom Lane
Date:
Subject: Re: [NOVICE] Fwd: tsearch2 in Postgres 9.5