| 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: | Whole Thread | Raw Message | 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? |