Hi All,
I am having a problem with getting tsearch2 installed and working. And
before I start, I know that postgresql 8.2 will be end of lifed at the end of
this year. We can't move to a newer version for support reasons :( . This
postgresql instance will be a backup of the main instance, and will receive the
dump files nightly. So, I tried to restore the database to the backup instance,
and got a bunch of errors among them was "to_tsvector not being found". I
realized that I didn't install tsearch2, so I went ahead a compiled it from the
contrib/tsearch2 directory and install it. I then went ahead and did a:
postgres name_of_db -U postgres -f tsearch2.sql (in the contrib/tsearch2
directory)
What I got was a bunch of:
psql:tsearch2.sql:20: ERROR: current transaction is aborted, commands
ignored until end of transaction block
starting at the lexize function and ending at the CREATE OPERATOR CLASS
gin_tsvector_ops in the tsearch2.sql
I then did:
name_of_db=# \df to_tsvector
List of functions
Schema | Name | Result data type | Argument data types
--------+-------------+------------------+---------------------
public | to_tsvector | tsvector | oid, text
public | to_tsvector | tsvector | text
public | to_tsvector | tsvector | text, text
But when I tried:
name_of_db=# select to_tsevector('this is one');
ERROR: function to_tsevector("unknown") does not exist
LINE 1: select to_tsevector('this is one');
^
HINT: No function matches the given name and argument types. You may need to
add explicit type casts.
I'm kinda clueless on where to go next to get this database up and running.
Some help please?
-Thanks,
Tino
