> Jonathan Villa schrieb: > >> 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 > > I think you running a linux/unix machine? > Have you executed ldconfig or similiar after you installed tsearch2? > Is the tsearch2.so in your library path? > Yes, I'm running on Linux I did not try ldconfig, however I just have... and same result tsearch2.so is in /usr/local/pgsql/lib and my home /usr/local/pgsql Also, logs say the same thing that fts.out says *shrug* ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly