Re: Regexps and Indices.

On Tue, 22 Apr 2003, Brian Piatkus wrote:

> Hi,
>     I'm sure that this has come up many times before but :
>
> I have just upgraded from 7.0.2 to 7.2.2 using the latest Mandrake 9.0 RPMS.
> The database structure is unchanged but I now find that the db refuses to use
> the available index WHERE NAME ~ '^NAME' even with enable_seqscan set off. Am
> I missing something ?

It's possible that you initialized the database in something other than
"C" locale which disables the optimization that uses indexes for
regexp/like (see past discussions in the archives for details).