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.

With best regards

--
Mario Günterberg
mattheis. werbeagentur
IT Engineer / Projektleiter

Zillestrasse 105a. D - 10585 Berlin
Tel#49-(0)30 . 34 80 633 - 0
Fax#49-(0)30 . 34 80 633 50
http://www.mattheis-berlin.de

Wenn Sie glauben, dies sei ein großes Problem - warten Sie mal ab,
bis wir versuchen die Lösung zu finden. (Walter Matthau)