Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers-win32 by date

Next:From: Thomas KellererDate: 2004-12-22 16:26:47
Subject: Re: locales and encodings on Windows
Previous:From: Magnus HaganderDate: 2004-12-22 12:14:34
Subject: Re: locales and encodings on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group