Anyone with any TSearch2 experience on FreeBSD? Any known Gotchas? Postgres 7.3
Postgres is working fine and the Port for contrib seemed to install okay. tsearch2.so is indeed in the below directory and permissions look right.
$ psql database < tsearch2.sql
SET
BEGIN
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'pg_ts_dict_pkey' for table 'pg_ts_dict'
CREATE TABLE
ERROR: Load of file /usr/local/lib/postgresql/tsearch2.so failed: dlopen '/usr/local/lib/postgresql/tsearch2.so' failed. (/usr/local/lib/postgresql/tsearch2.so: Undefined symbol "errcode_for_file_access")
ERROR: current transaction is aborted, queries ignored until end of transaction block
ERROR: current transaction is aborted, queries ignored until end of transaction block
Thanks
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
