Locale and indexes: howto?

From: Reg Me Please <regmeplease(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Locale and indexes: howto?
Date: 2007-11-05 20:27:27
Message-ID: 200711052127.27617.regmeplease@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI all.

While reading chapter 11 of v8.2 I've encountered this sentence:

However, if your server does not use the C locale you will need to create the
index with a special operator class to support indexing of pattern-matching
queries.

Well, I'd like to use the C locale at least for PGSQL.
Accordingly to my system (Linux, of course) these are my locale settings:

LANG=it_IT.UTF-8
LC_CTYPE="it_IT.UTF-8"
LC_NUMERIC="it_IT.UTF-8"
LC_TIME="it_IT.UTF-8"
LC_COLLATE=C
LC_MONETARY="it_IT.UTF-8"
LC_MESSAGES="it_IT.UTF-8"
LC_PAPER="it_IT.UTF-8"
LC_NAME="it_IT.UTF-8"
LC_ADDRESS="it_IT.UTF-8"
LC_TELEPHONE="it_IT.UTF-8"
LC_MEASUREMENT="it_IT.UTF-8"
LC_IDENTIFICATION="it_IT.UTF-8"
LC_ALL=

(I'm Italian, I think).

So the "locale" itself seems to be a little bit more complex than I thought.
I already use the C language collation schema, very useful in directory
listings. Should I install PGSQL with also the LC_CTYPE=C?
Or what?

Many thanks in advance.

--
Reg me Please

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-11-05 22:10:54 Re: How to transfer from place to plase without backup/restore
Previous Message andy 2007-11-05 20:09:12 Re: Is there a way to tell how far along a COPY is in the process?