Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-24 Thread judexhuang
On Apr 23, 4:11 pm, [EMAIL PROTECTED] wrote: > On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote: > > > > > On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote: > > > [EMAIL PROTECTED] writes: > > > > When I try to initiate tsearch2 in 8.2.4, I got the following error. > > >

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-24 Thread judexhuang
On Apr 23, 2:10 am, [EMAIL PROTECTED] (Martijn van Oosterhout) wrote: > On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote: > > [EMAIL PROTECTED] writes: > > > When I try to initiate tsearch2 in 8.2.4, I got the following error. > > > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-24 Thread judexhuang
On Apr 23, 12:31 am, [EMAIL PROTECTED] (Tom Lane) wrote: > [EMAIL PROTECTED] writes: > > When I try to initiate tsearch2 in 8.2.4, I got the following error. > > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so": > > missing magic block > > Apparently you have a pre-8.2 version instal

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-22 Thread Martijn van Oosterhout
On Mon, Apr 23, 2007 at 12:31:32AM -0400, Tom Lane wrote: > [EMAIL PROTECTED] writes: > > When I try to initiate tsearch2 in 8.2.4, I got the following error. > > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so": > > missing magic block > > Apparently you have a pre-8.2 version inst

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-22 Thread Tom Lane
[EMAIL PROTECTED] writes: > When I try to initiate tsearch2 in 8.2.4, I got the following error. > ERROR: incompatible library "/usr/local/pgsql/lib/tsearch2.so": > missing magic block Apparently you have a pre-8.2 version installed in /usr/local. Update. regards, tom lan

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-22 Thread judexhuang
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:

Re: [GENERAL] can't start tsearch2 in 8.2.4

2007-04-22 Thread Patrick TJ McPhee
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

[GENERAL] can't start tsearch2 in 8.2.4

2007-04-22 Thread judexhuang
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": missi