On Apr 23, 12:31 am, [EMAIL PROTECTED] (Tom Lane) wrote:
> [EMAIL PROTECTED] writes:
> > When I try to initiate tsearch2 in 8.2.4, I got the following error.
> > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so":
> > missing magic block
>
> Apparently you have a pre-8.2 version installed in /usr/local.
> Update.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
Thank you for your help.
You're absolutely correct. I cleaned up all the 8.1 and got a lot
further.
After runing psql dbname < tsearch2.sql, there are many SETs, then
...
SET
psql:tsearch2.sql:7: tsearch2.sql: Too many open files
RESET client_min_messages;
RESET
--tsvector
SELECT '1'::tsvector;
psql:tsearch2.sql:12: ERROR: type "tsvector" does not exist
LINE 1: SELECT '1'::tsvector;
^
...
Any ides about "Too many open files? It never happen to me in the
past and I don't know how many times I have successfully done this in
the past.
A side note, I noticed, I have to run the SQL script int the sql
directory, i.e. I can't do psql dbname < /dirname/tsearch2.sql
Regards
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
