On Wed, 3 Oct 2007, Alban Hertroys wrote:
Alban Hertroys wrote:The only odd thing is that to_tsvector('dutch', 'some dutch text') now returns '|' for stop words... For example: select to_tsvector('nederlands', 'De beste stuurlui staan aan wal'); to_tsvector ------------------------------------------------ '|':1,5 'bes':2 'wal':6 'staan':4 'stuurlui':3I found the cause. The stop words list I found contained comments prefixed by '|' signs. Removing the contents and recreating the database solved the problem. Just updating the reference didn't seem to help...
you need to recreate tsvector field and index, after changing any dicts.
There's undoubtedly some cleaner way to replace the stop words list, but at the current stage of our project this was the simplest to achieve.
Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@xxxxxxxxxx, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
