Re: Server locale?
От
Karel Zak
Тема
Re: Server locale?
Дата
Msg-id
20021007092816.E32143@zf.jcu.cz
Ответ на
Re: Server locale? (Tom Lane)
Список
Дерево обсуждения
Server locale? Martijn van Oosterhout <kleptog@svana.org>
Re: Server locale? Tom Lane <tgl@sss.pgh.pa.us>
Re: Server locale? Karel Zak <zakkr@zf.jcu.cz>
Re: Server locale? Martijn van Oosterhout <kleptog@svana.org>
Re: Server locale? Karel Zak <zakkr@zf.jcu.cz>
Re: Server locale? Tom Lane <tgl@sss.pgh.pa.us>
Re: Server locale? Karel Zak <zakkr@zf.jcu.cz>
Re: Server locale? Martijn van Oosterhout <kleptog@svana.org>
Re: Server locale? Karel Zak <zakkr@zf.jcu.cz>
Re: Server locale? Tom Lane <tgl@sss.pgh.pa.us>
Re: Server locale? Bruce Momjian <pgman@candle.pha.pa.us>
Re: Server locale? Martijn van Oosterhout <kleptog@svana.org>
Re: Server locale? Tom Lane <tgl@sss.pgh.pa.us>
On Sat, Oct 05, 2002 at 08:39:39PM -0400, Tom Lane wrote:
> Martijn van Oosterhout writes:
> > Can you retrieve what the server is using for LOCALE settings? In
> > particular, what the collate order is? It seems that my index is sorting
> > case insensetively, and I can't see a reason why.
>
> You can run contrib/pg_controldata (to become mainstream in 7.3 btw)
> to see the server's LC_COLLATE and LC_CTYPE settings.
and by "SHOW ALL" or SHOW LC_ [ COLLATE | ... ] commands too.
Karel
--
Karel Zak
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
В списке pgsql-general по дате отправления
