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
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? |