| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com> |
| 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 22:06:59 |
| Message-ID: | 26431.1072822019@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Mike Nolan <nolan(at)gw(dot)tssi(dot)com> writes:
> 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.
Yeah. There have been some discussions on pgsql-hackers about
defaulting to C locale instead of honoring LANG, but we haven't done
anything.
> Dumb question of the hour: How does one find out what locale a
> DB is initialized in?
In 7.4, you can just "show lc_collate". In prior versions you need
to use pg_controldata to see what's stored in pg_control.
BTW, 7.4 also has a specialized index opclass that can be used to create
LIKE-compatible indexes even if you are using a non-C locale.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith C. Perry | 2003-12-30 22:11:51 | Re: 'like' refuses to use an index??? |
| Previous Message | Jim C. Nasby | 2003-12-30 21:54:47 | Re: Is my MySQL Gaining ? |