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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general