[GENERAL] How to get fast ~ operator using C locale

2007-07-05 Thread Artur Rataj
Hello, I want to have pg use fast indexing for ~ operator. Is setting C locale for this is still necessary? If yes, is it enough to initdb/createdb with C locale? If it is not enough, why setting locale to C and starting postmaster still gives other locale, for example, pl_PL, in postmaster log "i

Re: [GENERAL] How to get fast ~ operator using C locale

2007-07-05 Thread Artur Rataj
: LC_MESSAGES=pl_PL.UTF-8 DEBUG: LC_MONETARY=C DEBUG: LC_NUMERIC=C DEBUG: LC_TIME=C So, does it mean that the server does not really use C locale? On 7/5/07, Dimitri Fontaine <[EMAIL PROTECTED]> wrote: Hi, Le jeudi 05 juillet 2007, Artur Rataj a écrit: >

[GENERAL] How to get fast ~ operator using C locale

2007-07-09 Thread Artur Rataj
Hello, I want to have pg use fast indexing for ~ operator. Is setting C locale for this is still necessary? If yes, is it enough to initdb/createdb with C locale? If it is not enough, why setting locale to C and starting postmaster still gives other locale, for example, pl_PL, in postmaster log "i