Server crash on postgresql 8.2.4 with tsearch2

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