Re: Regexps and Indices.

BTW, What **IS** the the language 'C'? I don't talk to people like:

'if( !happy(honey)){
  what_went_wrong_today();
}'

;-)

Brian Piatkus wrote:
> 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
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>