Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: can't start tsearch2 in 8.2.4


  • From: ptjm(at)interlog(dot)com (Patrick TJ McPhee)
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: can't start tsearch2 in 8.2.4
  • Date: Sun, 22 Apr 2007 21:01:32 -0000
  • Message-id: <132nj9clsk71gb9(at)corp(dot)supernews(dot)com>

In article <1177213190(dot)291022(dot)39730(at)d57g2000hsg(dot)googlegroups(dot)com>,
 <judexhuang(at)gmail(dot)com> wrote:
% On Apr 20, 11:38 pm, judexhu(dot)(dot)(dot)(at)gmail(dot)com 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
ptjm(at)interlog(dot)com



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group