Strange. I use FreeBSD 5.0 with 7.4devel and 7.3.2. No problem.
Did you compile tsearch module in contrib directory of pgsql src tree that was
used for compile your pgsql installation?
Diogo de Oliveira Biazus wrote:
> Hi,
>
> I'm having a problem when I try to run the SQL commands that install the
> tsearch2 module,
> When I ran the SQL script I've got this message:
>
> SET
> BEGIN
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> 'pg_ts_dict_pkey' for table 'pg_ts_dict'
> psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:14:
> NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
> 'pg_ts_dict_pkey' for table 'pg_ts_dict'
> CREATE TABLE
> CREATE INDEX
> ERROR: Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
> '/usr/local/pgsql/lib/tsearch.so' failed.
> (/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout")
> psql:/usr/ports/databases/postgresql7/work/postgresql-7.3.1/contrib/tsearch2/tsearch.sql:22:
> ERROR: Load of file /usr/local/pgsql/lib/tsearch.so failed: dlopen
> '/usr/local/pgsql/lib/tsearch.so' failed.
> (/usr/local/pgsql/lib/tsearch.so: Undefined symbol "stdout") ...
>
> I'm running a PostgreSQL 7.3.1 on a FreeBSD 5.0
> Could anybody help me?
>
> Thanks in advance,
>
--
Teodor Sigaev E-mail: teodor@sigaev.ru