Home » Mailing list archives » openbsd-misc » 2007 » June » 24

LC_COLLATE and PostgreSQL

Previous message: [thread] [date] [author]
Next message: [thread] [date] [author]
[view in full thread]
From: bsd_news <bsd_news@...>
To: <misc@...>
Subject: LC_COLLATE and PostgreSQL
Date: Sunday, June 24, 2007 - 4:41 pm

Hi

I like OpenBSD very much but:

I have not proper sorts in my PostgreSQL 8.1 database on my OpenBSD 4.0

server.

I had set in /etc/profile the LC_COLLATE to pl_PL.ISO8859-2.

The PostgreSQL cluster was created by command:

initdb --locale=pl_PL.ISO8859-2 -E LATIN2 --lc-messages=C --lc-monetary=C

--lc-numeric=C --lc-time=C -D /var/postgresql/data.


I do not know is there possibility to fix this problem - maybe OpenBSD now

support only C and POSIX collation ?


Thanks for every help,

best regards,

Artur


ps. sorry for my poor English
Previous message: [thread] [date] [author]
Next message: [thread] [date] [author]
Messages in current thread:
LC_COLLATE and PostgreSQL, bsd_news, (Sun Jun 24, 4:41 pm)
Re: LC_COLLATE and PostgreSQL, Philip Guenther, (Sun Jun 24, 11:07 pm)
Re: , Artur Litwinowicz, (Mon Jun 25, 5:50 am)
Re: LC_COLLATE and PostgreSQL, Joachim Schipper, (Mon Jun 25, 4:47 pm)
Re: , Artur Litwinowicz, (Tue Jun 26, 6:35 am)
Re: LC_COLLATE and PostgreSQL, Valentin Kozamernik, (Thu Jun 28, 5:18 am)
Re: , Artur Litwinowicz, (Thu Jun 28, 6:03 am)
Re: LC_COLLATE and PostgreSQL, Ben Calvert, (Sun Jun 24, 9:47 pm)
Re: , Artur Litwinowicz, (Mon Jun 25, 5:38 am)