In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> wrote:
% On Apr 20, 11:38 pm, [EMAIL PROTECTED] wrote:
% > 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
%
% I have seen discussion about adding PG_MODULE_MAGIC to .c or .h code.
% Does anyone have suggestion about where I should add this to tsearch2
% code, and how should I rebuild tsearch2 with this?
Probably the easiest thing is to use the tsearch2 from the 8.2 contrib
directory. It already works with 8.2.
--
Patrick TJ McPhee
North York Canada
[EMAIL PROTECTED]
---------------------------(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
