FullText Searching: The Dilemma

Max Kanat-Alexander mkanat at bugzilla.org
Tue Jun 26 23:14:50 UTC 2007

On Tue, 26 Jun 2007 15:34:09 +0100 Gervase Markham <gerv at mozilla.org>
> 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

Competent, Friendly Bugzilla Services. And Everything Else, too.

More information about the developers mailing list