ERROR: text search configuration "pg_catalog.english" does not exist

From: Tim Child <tim(at)timc3(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ERROR: text search configuration "pg_catalog.english" does not exist
Date: 2008-03-11 16:38:29
Message-ID: 27A81C20-AF22-4205-8D38-74F3F03A18BB@timc3.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-03-11 16:51:18 Re: Database OID xxxxx now seems to belong to "foo"
Previous Message Richard Huxton 2008-03-11 15:56:24 Re: Database OID xxxxx now seems to belong to "foo"