indexes on text columns - Mailing list pgsql-admin

From Martins Zarins
Subject indexes on text columns
Date
Msg-id 3BBCA4AF.11553.14D65F@localhost
Whole thread Raw
Responses Re: indexes on text columns
List pgsql-admin
Hi , all!

I'm using 7.1.3 with --enable-locale
my locale is lv_LV.ISO8859-13
And sort works prety fine.

I have a table with text column and index in it.
When I make some
EXPLAIN select id from text_table where text_column = 'some_text'
it reports that sequential scan will be used
BUT
When I recompile postgres WITHOUT --enable-locale, index scan ir
working fine, but sort don't.

Is this a bug or I missed some configuration about locale and
indeces?

Mark

pgsql-admin by date:

Previous
From: hodges@xprt.net
Date:
Subject: Re: Authorization problem
Next
From: Stephan Szabo
Date:
Subject: Re: indexes on text columns