hi, I have compiled postgresql 8.2.4 on a debian etch witch french snowball stemmer . I applied the lastest patch send by Teodor Sigaev (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/tsearch_snowball_82-20070504.gz)
and my backend still crash. I tested on 2 differents server both with etch, one with i386 the other with amd64. The first crash on ts_vector when the parameter string is longer than 200 characters. The second crash on lexize If you have other patch to try I will do it :) If for you there is no bug, I don't understand what's appen to my servers. any idea ? thank Regards ---------------------------(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