Re: [GENERAL] [tsearch2] Problem with case sensitivity (or with creating own dictionary)

2013-08-07 Thread Krzysztof xaru Rajda
Ok, so to be sure if I understand everything - first I should install a postgresql-contrib extension. Next, there will appear a contrib/dict_int directory with dict_int sourcecode inside, which I can modify. Then, I'll be able to install this modified dictionary, and it would be working properl

Re: [GENERAL] [tsearch2] Problem with case sensitivity (or with creating own dictionary)

2013-08-05 Thread Oleg Bartunov
Please, take a look on contrib/dict_int and create your own dict_noop. It should be easy. I think you could document it and share with people (wiki.postgresql.org ?), since there were other people interesting in noop dictionary. Also, don't forget to modify your configuration - use ts_debug(), i

[GENERAL] [tsearch2] Problem with case sensitivity (or with creating own dictionary)

2013-08-05 Thread Krzysztof xaru Rajda
Hello, I encountered such a problem. my goal is to extract links from a text using tsearch2. Everything seemed to be well, unless I got some youtube links - there are some small and big letters inside, and a tsearch parser is lowering everything (from http://youtube.com/Y6dsHDX I got http://y

[GENERAL] [tsearch2] Problem with case sensitivity (or with creating own dictionary)

2013-08-05 Thread Krzysztof xaru Rajda
Hello, I encountered such a problem. my goal is to extract links from a text using tsearch2. Everything seemed to be well, unless I got some youtube links - there are some small and big letters inside, and a tsearch parser is lowering everything (from http://youtube.com/Y6dsHDX I got http://y

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread John DeSoi
On Oct 31, 2008, at 6:30 AM, Jodok Batlogg wrote: nevertheless i still have the problem that words with '/' are beeing interpreted as file paths instead of words. any idea how i could tweak this? The easiest solution I found was to replace '/' with a space before parsing the text. John

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
Sergio, On Fri, 31 Oct 2008, Ivan Sergio Borgonovo wrote: On Fri, 31 Oct 2008 13:10:20 +0300 (MSK) Oleg Bartunov <[EMAIL PROTECTED]> wrote: Jodok, you got what's you defined. Please, read documentation. In short, word doesn't indexed if it is not recognized by any dictionaried from stack of

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
On Fri, 31 Oct 2008, Jodok Batlogg wrote: hi oleg, thanks for your quick response, 2008/10/31 Oleg Bartunov <[EMAIL PROTECTED]>: Jodok, you got what's you defined. Please, read documentation. In short, word doesn't indexed if it is not recognized by any dictionaried from stack of dictionarie

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Ivan Sergio Borgonovo
On Fri, 31 Oct 2008 13:10:20 +0300 (MSK) Oleg Bartunov <[EMAIL PROTECTED]> wrote: > Jodok, > > you got what's you defined. Please, read documentation. > In short, word doesn't indexed if it is not recognized by any > dictionaried from stack of dictionaries. Put stemming dictionary > at the end, w

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Jodok Batlogg
hi oleg, thanks for your quick response, 2008/10/31 Oleg Bartunov <[EMAIL PROTECTED]>: > Jodok, > > you got what's you defined. Please, read documentation. > In short, word doesn't indexed if it is not recognized by any > dictionaried from stack of dictionaries. Put stemming dictionary at the end

Re: [GENERAL] tsearch2 problem

2008-10-31 Thread Oleg Bartunov
Jodok, you got what's you defined. Please, read documentation. In short, word doesn't indexed if it is not recognized by any dictionaried from stack of dictionaries. Put stemming dictionary at the end, which recognizes everything. Oleg On Fri, 31 Oct 2008, Jodok Batlogg wrote: we're using tsea

[GENERAL] tsearch2 problem

2008-10-31 Thread Jodok Batlogg
we're using tsearch2 with the german dictionary http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/ispell/ispell-german-compound.tar.gz for fulltext search. the indexing is configured as follows: CREATE TEXT SEARCH DICTIONARY public.german ( TEMPLATE = ispell, DictFile = german,

Re: [GENERAL] tsearch2 problem

2008-04-23 Thread Tom Lane
Craig Ringer <[EMAIL PROTECTED]> writes: > Is there any chance your contrib package does not match the core > PostgreSQL version or is from a different source? qsort_arg was added in 8.2, so it seems certain he's trying to load an 8.2 tsearch2 into his 8.1 engine. regards,

Re: [GENERAL] tsearch2 problem

2008-04-23 Thread Craig Ringer
Corin Schedler wrote: > Hi all, > > I'm having some trouble installing tsearch2 in to my database. I'm > running 8.1.11 on CentOS 5. Where did the packages come from? Where they part of CentOS / RHEL, or are they obtained from somewhere else? Is there any chance your contrib package does not mat

[GENERAL] tsearch2 problem

2008-04-23 Thread Corin Schedler
Hi all, I'm having some trouble installing tsearch2 in to my database. I'm running 8.1.11 on CentOS 5. I'm getting the following output after trying 'psql db < tsearch2.sql'. SET BEGIN NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "pg_ts_dict_pkey" for table "pg_ts_dict" CREATE

Re: [GENERAL] tsearch2 problem

2007-05-14 Thread Oleg Bartunov
On Mon, 14 May 2007, Marcel wrote: hi I'm using tsearch2 first time. The guide suggusts there are 4 weight labels: A, B,C, D. Can it be more flexible? For example, Is it possible to assign each word an different weight (real value). Do you want to have more than 4 labels ? Unfortunately, no.

Re: [GENERAL] tsearch2 problem

2007-05-14 Thread Hannes Dorbath
On 14.05.2007 11:12, Marcel wrote: I'm using tsearch2 first time. The guide suggusts there are 4 weight labels: A, B,C, D. Can it be more flexible? For example, Is it possible to assign each word an different weight (real value). No, AFAIK. -- Regards, Hannes Dorbath --

[GENERAL] tsearch2 problem

2007-05-14 Thread Marcel
hi I'm using tsearch2 first time. The guide suggusts there are 4 weight labels: A, B,C, D. Can it be more flexible? For example, Is it possible to assign each word an different weight (real value). Thanks, -- Marcel