Search Postgresql Archives

Re: Adding contrib modules

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> 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.


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux