FullText Searching: The Dilemma

[Max Kanat-Alexander]

On Tue, 26 Jun 2007 15:34:09 +0100 Gervase Markham <gerv at mozilla.org>
wrote:
> We could do that. How hard would it be to convert b.m.o.? Are there 
> scripts, or do all conversions have to be done by hand? Do we know
> how MoCo IT would feel about supporting Postgres? Do we feel the
> Postgres support is stable enough? Are there other downsides?

	We actually talked about it during the last upgrade, I believe.

	The problem is that currently PostgreSQL is case-sensitive for
searches, which is too much of a pain.

	If there was a way to make the whole DB use a case-insensitive
search and collation (and still be able to use indexes), we could do
that.

	-Max
-- 
http://www.everythingsolved.com/
Competent, Friendly Bugzilla Services. And Everything Else, too.