From: | "Keith C(dot) Perry" <netadmin(at)vcsn(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Mike Nolan <nolan(at)gw(dot)tssi(dot)com>, Dima Tkach <dmitry(at)openratings(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: 'like' refuses to use an index??? |
Date: | 2003-12-30 22:22:34 |
Message-ID: | 1072822954.3ff1faaa431b7@webmail.vcsn.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
> 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.
Show the pg_controldata program work in 7.4? If not, shouldn't it be removed
from the docs in favor of the show method of finding out the locale.
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com
____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dima Tkach | 2003-12-30 22:33:31 | Re: 'like' refuses to use an index??? |
Previous Message | Mike Nolan | 2003-12-30 22:22:23 | Re: 'like' refuses to use an index??? |