Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 22 Dec 2004 08:42:39 -0500
- Message-id: <41C979CF(dot)5090709(at)dunslane(dot)net>
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
- References:
- 8.0 collate and index use
- From: Richard Greenwood
- 8.0 collate and index use
- Prev by Date: Re: locales and encodings on Windows
- Next by Date: Re: locales and encodings on Windows
- Previous by thread: 8.0 collate and index use
- Next by thread: Re: locales and encodings on Windows
- Indexes: