TSearch - Bulgarian

Started by Hristo Filipovover 18 years ago3 messagesgeneral
Jump to latest
#1Hristo Filipov
christod@ciela.net

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

#2Christian Rengstl
Christian.Rengstl@klinik.uni-regensburg.de
In reply to: Hristo Filipov (#1)
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@ciela.net>
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.

Show quoted text

Can someone help us?

Hristo Filipov

#3Hristo Filipov
christod@ciela.net
In reply to: Christian Rengstl (#2)
Re: TSearch - Bulgarian

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@klinik.uni-regensburg.de]
Sent: Thursday, September 27, 2007 4:43 PM
To: Hristo Filipov; pgsql-general@postgresql.org
Subject: Re: [GENERAL] 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@ciela.net>
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.

Show quoted text

Can someone help us?

Hristo Filipov