| From: | Anrik Drenth <drentha(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Fwd: tsearch2 in Postgres 9.5 |
| Date: | 2017-09-12 22:05:23 |
| Message-ID: | CAEdS=woDQ_N0ahv_-tqxp+hDfawx1LRmbcVY6azLpjRwahiN0w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2017-09-13 00:02:42 | Re: Fwd: tsearch2 in Postgres 9.5 |
| Previous Message | Merlin Moncure | 2017-09-05 18:52:45 | Re: Adding SSD to HDD-based System |