Re: Adding contrib modules

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.

In response to

Responses

Browse pgsql-general by date

  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