Re: 8.0 collate and index use - Mailing list pgsql-hackers-win32

From Andrew Dunstan
Subject Re: 8.0 collate and index use
Date
Msg-id 41C979CF.5090709@dunslane.net
Whole thread Raw
In response to 8.0 collate and index use  (Richard Greenwood <richard.greenwood@gmail.com>)
List pgsql-hackers-win32

Richard Greenwood wrote:

>I figure the index non-use issue is due to collate and/or ctype, so I:
>   initdb --locale=C --lc-collate=C
>and indexes are now being used as expected.
>
>Did I address it in the best manner?
>
>

Yes, I think so.

>Did I overlook anything that should have been obvious?
>
>

Not that I know of

>Should a new windows postgres user be expected to spot this and address it?
>
>

It is not specifically a Windows issue - it has bitten me on Unix. And
it is mentioned in the FAQ iirc.

cheers

andrew


pgsql-hackers-win32 by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: locales and encodings on Windows
Next
From: Thomas Kellerer
Date:
Subject: Re: locales and encodings on Windows