Re: Adding contrib modules

> Jonathan Villa schrieb:
>> I'm having some trouble getting one of the contrib modules to load
>> correctly...
>>
>> it's for tsearch2.sql
>>
>> I've tried
>>
>> ./configure --prefix=/usr/local/pgsql
>> gmake all
>> gmake install
>>
>> and I've also tried, from the contrib/tsearch2/ dir,
>>
>> gmake
>>
>> but that fails when looking for flex, which by the way, is installed.
>>
>> When attempting the former method, and trying to run
>>
>> psql -d mydb -f tsearch2.sql
>>
>> I get all kinds of errors...
>>
>> specifically,
>>
>> type "tsvector" does not exist
>>
>>
>> I've googled for a solution/explaination but I'm still in the dark.
>
> Try from source root gmake -C contrib/tsearch2 and
> gmake -C contrib/tsearch2 install.
>
> What version of flex is installed?
> Try flex --version.
> On my machine works flex 2.5.4 fine.
>
>

thanks, that seemed to work ok... now.. how do I use tsearch2?  meaning,
how do I run the script?  is it against the database I was to use it with?
 example

psql -d mytestdb < tsearch2.sql

Granted, this is a new database that has not worked with tsearch2 before.