Re: ERROR: text search configuration "pg_catalog.english" does not exist - Mailing list pgsql-general

From Richard Huxton
Subject Re: ERROR: text search configuration "pg_catalog.english" does not exist
Date
Msg-id 47D6D636.6060808@archonet.com
Whole thread Raw
In response to ERROR: text search configuration "pg_catalog.english" does not exist  (Tim Child <tim@timc3.com>)
List pgsql-general
Tim Child wrote:
> Hi, I am trying to configure Full Text Search on PostgreSQL 8.3 but I
> seem to be missing pg_catalog.english as I get the follow when I try and
> do this:

> tsvector_update_trigger(body_tsv, 'pg_catalog.english', notes);

> Error:
>
> ERROR:  text search configuration "pg_catalog.english" does not exist
> SQL state: 42704

The \dF commands show your settings (in psql) - what does \dF show for you?

You might want to check your dictionaries are all there with \dFd too.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postgre vs MySQL
Next
From: "Dann Corbit"
Date:
Subject: Re: postgre vs MySQL