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 18:14:43
Message-ID: 21780.206.166.83.50.1124302483.squirrel@mail.innovativesource.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Jonathan Villa schrieb:
>
>> 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.
>
> Yes, this is the right way. See
> $PGSRC/contrib/tsearch2/docs/tsearch-V2-intro.html chapter
> ADDING TSEARCH2 FUNCTIONALITY TO A DATABASE.
>

Thanks... at least know I'm doing to correctly... but I still get the
errors. I've done everything as it states on the tsearch-V2-intro.html
page... and then I run

psql ftstest < tsearch2.sql &> fts.out

for testing of course

the fts.out file has things like

ERROR: type "tsvector" does not exist
ERROR: type "tsquery" does not exist
ERROR: function lexize("unknown", "unknown") does not exist

I'm totally baffled... I'm running 7.4.8 by the way

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2005-08-17 18:16:34 Re: Generating random values.
Previous Message marcelo Cortez 2005-08-17 18:12:55 postgres 8.x on debian