Re: 'like' refuses to use an index???

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