Re: 8.0 collate and index use

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Richard Greenwood <richard(dot)greenwood(at)gmail(dot)com>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: 8.0 collate and index use
Date: 2004-12-22 13:42:39
Message-ID: 41C979CF.5090709@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Thomas Kellerer 2004-12-22 16:26:47 Re: locales and encodings on Windows
Previous Message Magnus Hagander 2004-12-22 12:14:34 Re: locales and encodings on Windows