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