From: | "Jonathan Villa" <jonathan(at)innovativesource(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Adding contrib modules |
Date: | 2005-08-17 15:25:28 |
Message-ID: | 21054.206.166.83.50.1124292328.squirrel@mail.innovativesource.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Csaba Nagy | 2005-08-17 15:35:37 | Re: Finding nearest numeric value |
Previous Message | Sean Davis | 2005-08-17 15:21:31 | Re: Finding nearest numeric value |