When I try to initiate tsearch2 in 8.2.4, I got the following error. $ psql emedia_db < tsearch2.sql SET BEGIN NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_dict_pkey" for table "pg_ts_dict" CREATE TABLE ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so": missing magic block
.................. Does anyone know if there is a fix available? Thanks ---------------------------(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