| 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
| 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 |