Wei Weng <[EMAIL PROTECTED]> writes: > But then when I do a psql < tsearch2.sql, it complains: > bash-2.05a$ psql testdb < tsearch2.sql > ERROR: stat failed on file '$libdir/tsearch2': No such file or directory > Where did I do wrong??
Did you do "make install" after building tsearch2? If you did, maybe it installed tsearch2.so in the wrong place? ("pg_config --pkglibdir" will tell you what the backend thinks "$libdir" means.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match