Re: Regexps and Indices.

Hi
It turns out to be more than possible. Locale is set by default to en_GB.
Am I right in assuming that I need only to set LANG=C ? and should I also do
this for the environment of the running postmaster ?


On Tuesday 22 Apr 2003 20:59, you wrote:
> 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).
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster