| 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: | Whole Thread | Raw Message | 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
| 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" |