Re: Need help with full text index configuration

From: Brian Hirt <bhirt(at)mobygames(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help with full text index configuration
Date: 2010-07-28 20:19:31
Message-ID: 7ECCA59E-F5A5-4B21-A849-729794891CFC@mobygames.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom,

Thanks for the quick reply. Doing a frontend mapping was my next option since I really don't care about / and the ability to search on it. Preventing the parser from using the file tokenizer seemed like a better solution so I wanted to go down that path first (there are other false hits i was worried about too, like email, etc)

I'm really confused about what "ALTER TEXT SEARCH CONFIGURATION dict DROP MAPPING FOR file" actually does. The documentation seems to make it sound like it does what I want, but I guess it does something else.

--brian

On Jul 28, 2010, at 2:06 PM, Tom Lane wrote:

> Brian Hirt <bhirt(at)mobygames(dot)com> writes:
>> For example instead of the parser recognizing three asciiword it recognizes one asciiword and one file. I'd like a way to have the / just get parsed as blank.
>
> AFAIK the only good way to do that is to write your own parser :-(.
> The builtin parser isn't really configurable. (If you didn't mind
> maintaining a private version you could patch its state transition
> table manually, but that seems like a PITA.)
>
> For the case at hand it could be a pretty thin frontend to the builtin
> text parser --- just change / to space and then call the builtin one.
> contrib/test_parser/ might help you get started.
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-07-28 20:42:26 Re: Need help with full text index configuration
Previous Message raghu ram 2010-07-28 20:12:19 Pglesslog issue