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: ALTER TABLE useraccounts_contact ADD COLUMN notes_tsv tsvector; CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON useraccounts_contact FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(body_tsv, 'pg_catalog.english', notes); CREATE INDEX useraccounts_contact_entry_tsv ON useraccounts_contact USING gin(notes_tsv); UPDATE useraccounts_contact SET notes_tsv =to_tsvector(notes); Error: ERROR: text search configuration "pg_catalog.english" does not exist SQL state: 42704 In my postgresql.conf I have the following: # default configuration for text search default_text_search_config = 'pg_catalog.english' Thanks in advance. Tim Child |