Forum OpenACS Q&A: Odd tsearch2 error

Posted by Janine Ohmer on
Still working on those old sites moved to a new system.

Postgres version is 7.4.8 (remember, they didn't want me to upgrade anything). Tsearch2 installed from source as per usual. Inserts into cr_revisions are failing and I found this in PG's server log:

ERROR: could not load dictionary file "/usr/local/pgsql/share/contrib/english.dict"
CONTEXT: PL/pgSQL function "cr_revisions__ts_vec_iu_fn" line 5 at assignment
PL/pgSQL function "content_revision__new" line 54 at SQL statement
PL/pgSQL function "content_revision__new" line 15 at return
PL/pgSQL function "content_item__new" line 154 at assignment
PL/pgSQL function "news__new" line 54 at assignment
ERROR: relation "pg_ts_config" does not exist

I'm not sure which is the real error and which is fallout, but either way it's perplexing. I don't have english.dict in any of my PG installs. And pg_ts_config is the 8.x name for a table that used to be called pg_ts_cfg, which is there, but I haven't knowingly installed anything that would have introduced any 8.x code.

Has anyone seen this or have a guess as to what might really be wrong?

Thanks in advance!

2: Re: Odd tsearch2 error (response to 1)
Posted by Janine Ohmer on
The answer, for posterity:

The folks who set this up originally had apparently followed the directions here:

(or something similar)

to create an English dictionary from the iSpell data. After I created the dictionary, the error about the missing config went away.