| From: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
|---|---|
| To: | tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) |
| Cc: | dmitry(at)openratings(dot)com (Dima Tkach), pgsql-general(at)postgresql(dot)org (PostgreSQL General) |
| Subject: | Re: 'like' refuses to use an index??? |
| Date: | 2003-12-30 21:40:39 |
| Message-ID: | 200312302140.hBULeeAo002661@gw.tssi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> You didn't initdb in C locale ...
The documentation section on localization could use some enhancements
and maybe some more examples.
The 'c' locale isn't very well defined in the docs, except to say that it
is 'special' and is the default if no other locale is defined. That
section doesn't mention that you need that locale to get 'like' to
use an index, for example.
However, I think RH always sets the LANG environmental variable, so
that's going to be picked up by initdb, which means that the C locale
will NOT be used unless specifically asked for. Other OS packages may
also force the choice of a default LANG value.
Dumb question of the hour: How does one find out what locale a
DB is initialized in?
--
Mike Nolan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ericson Smith | 2003-12-30 21:44:36 | 7.4.1 RPMS |
| Previous Message | Dima Tkach | 2003-12-30 21:36:40 | Re: 'like' refuses to use an index??? |