Re: can't start tsearch2 in 8.2.4

On Apr 20, 11:38 pm, judexhu...@gmail.com wrote:
> When I try to initiate tsearch2 in 8.2.4, I got the following error.
>
> $ psql emedia_db < 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:  incompatible library "/usr/local/pgsql/lib/tsearch2.so":
> missing magic block
>
> ..................
>
> Does anyone know if there is a fix available?
>
> Thanks

I have seen discussion about adding PG_MODULE_MAGIC to .c or .h code.
Does anyone have suggestion about where I should add this to tsearch2
code, and how should I rebuild tsearch2 with this?

Thanks.