Thread: Server crash on postgresql 8.2.4 with tsearch2

Hi,
I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
tsearch.

I use french snowball package to compile a stemming lib -> dict_fr.so

Now if I do a query like this
 select to_tsvector('default', '... something with more than 200
chars');

-> result ok

but
 select to_tsvector('fr_FR', '... something with more than 200 chars');

-> server crash

Does anyone faced this bug ?
Is there a fix ?

Thank you for help

On Mon, 30 Apr 2007, philippe wrote:

> Hi,
> I'm tryng to upgrade a 8.1.3 server to 8.2.4 and I have a problem with
> tsearch.
>
> I use french snowball package to compile a stemming lib -> dict_fr.so
>
> Now if I do a query like this
> select to_tsvector('default', '... something with more than 200
> chars');
>
> -> result ok

it doesn't uses french snowball stemmer

>
> but
> select to_tsvector('fr_FR', '... something with more than 200 chars');
>
> -> server crash
>
> Does anyone faced this bug ?
> Is there a fix ?
>

have you reinstalled tsearch2 ? There was change in  snowball stemmer api.
Check mailing list archive for the same issue.

> Thank you for help
>
>
>
>
> ---------------------------(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
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Le lundi 30 avril 2007 à 20:13 +0400, Oleg Bartunov a écrit :
> On Mon, 30 Apr 2007, philippe wrote:

> > Now if I do a query like this
> > select to_tsvector('default', '... something with more than 200
> > chars');
> >
> > -> result ok
>
> it doesn't uses french snowball stemmer
>
Yes, it's just to show that tsearch is working by default

> >
> > but
> > select to_tsvector('fr_FR', '... something with more than 200 chars');
> >
> > -> server crash
> >
> have you reinstalled tsearch2 ? There was change in  snowball stemmer api.
> Check mailing list archive for the same issue.
>

I have reinstalled tsearch2,
I have also recompiled it with this patch
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82.gz

I still have the same problem.
I have found similar problem in the archive but not the same one

doing this
select lexize( 'fr', 'voyageur' );
don't crash