Forum OpenACS Q&A: tsearch- unable to apply regprocedure_update.sql

After applying the patch: regprocedure_7.4.patch

I took a guess that the following command would apply the SQL commands to the database but it returns this error.

[postgres][postgresql-7.4.7]>psql -f regprocedure_update.sql {DBNAME}

BEGIN
psql:regprocedure_update.sql:6: ERROR: relation "pg_ts_dict" does not exist
psql:regprocedure_update.sql:7: ERROR: current transaction is aborted, commands ignored until end of transaction block
.
.
.
psql:regprocedure_update.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block
COMMIT
VACUUM

Collapse
Posted by Dave Bauer on
It looks like tsearch2 is not installed in your database yet. You need to have tsearch2 installed before applying that patch.