Re: Server crash on postgresql 8.2.4 with tsearch2

[Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>]

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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83