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