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.
---------------------------(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
