> 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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
