indexes on text columns

From: "Martins Zarins" <mark(at)vestnesis(dot)lv>
To: pgsql-admin(at)postgresql(dot)org
Subject: indexes on text columns
Date: 2001-10-04 15:04:31
Message-ID: 3BBCA4AF.11553.14D65F@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2001-10-04 15:58:59 Re: indexes on text columns
Previous Message hodges 2001-10-04 13:24:22 Re: Authorization problem