> Jonathan Villa schrieb: >> I'm having some trouble getting one of the contrib modules to load >> correctly... >> >> it's for tsearch2.sql >> >> I've tried >> >> ./configure --prefix=/usr/local/pgsql >> gmake all >> gmake install >> >> and I've also tried, from the contrib/tsearch2/ dir, >> >> gmake >> >> but that fails when looking for flex, which by the way, is installed. >> >> When attempting the former method, and trying to run >> >> psql -d mydb -f tsearch2.sql >> >> I get all kinds of errors... >> >> specifically, >> >> type "tsvector" does not exist >> >> >> I've googled for a solution/explaination but I'm still in the dark. > > Try from source root gmake -C contrib/tsearch2 and > gmake -C contrib/tsearch2 install. > > What version of flex is installed? > Try flex --version. > On my machine works flex 2.5.4 fine. > > 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
