Hi Christian, Yes we know that we need to create Bulgarian dictionary first. Dictionaries like programs, and dictionaries like word list of our language. The Programs Dictionaries bothers me the most :-). Also how many word list dictionaries we need to build? 1. Stop words. 2. ??? currently we don’t need to make spell check so I guess we don’t have to build ispell dictionaries. I'm reading the guides one by one from the http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/, but I guess I'm just not good enough to find what we need. -----Original Message----- From: Christian Rengstl [mailto:Christian.Rengstl@xxxxxxxxxxxxxxxxxxxxxxxx] Sent: Thursday, September 27, 2007 4:43 PM To: Hristo Filipov; pgsql-general@xxxxxxxxxxxxxx Subject: Re: TSearch - Bulgarian You might have to create a Bulgarian dictionary first before you will be able to successfully use tsearch. Maybe some information here will help you: http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ Christian Rengstl M.A. Klinik und Poliklinik für Innere Medizin II Kardiologie - Forschung Universitätsklinikum Regensburg B3 1.388 Franz-Josef-Strauss-Allee 11 93053 Regensburg Tel.: +49-941-944-7230 >>> On Thu, Sep 27, 2007 at 3:17 PM, in message <003c01c80108$b550d9c0$1ff28d40$@net>, "Hristo Filipov" <christod@xxxxxxxxx> wrote: > Hello world! > > J!! We are Bulgarian developers currently working on some web project(server > must run on windows and linux) and we stop our choice for database at > PostgreSQL, which I may say offers great things at no cost at all :- P. > > So we have our tables ready after some times (new for psql, migrating > database from access) all works fine! Even better! But we can't get to run > FTS on PostgreSQL L. We have tables in locale Bulgaria_Bulgarian_1251, > Bulgaria_Bulgarian_UTF8. I read "Full- Text Search in PostgreSQL - A Gentle > Introduction" from Oleg Bartunov and Teodor Sigaev (great work guys!), and > it open my eyes in some way, but I still can't understand what I need to do > - so I can create FTS for Bulgarian language L and make TSearch work for us. > Can someone help us? > > > > Hristo Filipov ---------------------------(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
