Re: LC_COLLATE and PostgreSQL

2007-06-28 Thread Valentin Kozamernik
On Tue, 26 Jun 2007 at 12:35, Artur Litwinowicz wrote: O I think it is not good idea to change the code of OpenBSD by me. Years ago I was coding in C++ (at the University but with best mark ;). Now I am working for Oracle Corp. (PL/SQL and etc.) and I am a little out of practice ;) with

Re: LC_COLLATE and PostgreSQL

2007-06-28 Thread Artur Litwinowicz
Hi Valentin, thank You very, very much for Your answer. Your idea is great !!! I am very happy with this solution :) Of course I have to recall that pleasure with C/C++ coding but for now this is the best and fastest way for me. Have a nice day, Best regards :) Artur On Thu, 28 Jun

Re: LC_COLLATE and PostgreSQL

2007-06-26 Thread Artur Litwinowicz
O I think it is not good idea to change the code of OpenBSD by me. Years ago I was coding in C++ (at the University but with best mark ;). Now I am working for Oracle Corp. (PL/SQL and etc.) and I am a little out of practice ;) with C/C++. Maybe someone core OpenBSD Developer will agree

Re: LC_COLLATE and PostgreSQL

2007-06-25 Thread Artur Litwinowicz
Hi Ben, than You for answer. My PostgreSQL instance works fine. The problem is in OpenBSD unfortunately. PostgreSQL uses COLLATION support served by operating system and default BSD has C and POSSIX COLLATION. I am looking for solution for this problem. I need native support for polish

Re: LC_COLLATE and PostgreSQL

2007-06-25 Thread Artur Litwinowicz
Hi Philip, thank You match for answer and nice words :). I am starting be concern for my problem but my love for OpenBSD is stronger then sort problems (data on my web are sorted not correctly) and I do not want to change system on may server. Maybe in the nearest feature OpenBSD

Re: LC_COLLATE and PostgreSQL

2007-06-25 Thread Joachim Schipper
On Mon, Jun 25, 2007 at 11:50:10AM +0200, Artur Litwinowicz wrote: Hi Philip, thank You match for answer and nice words :). I am starting be concern for my problem but my love for OpenBSD is stronger then sort problems (data on my web are sorted not correctly) and I do not want to change

LC_COLLATE and PostgreSQL

2007-06-24 Thread bsd_news
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

Re: LC_COLLATE and PostgreSQL

2007-06-24 Thread Ben Calvert
On Jun 24, 2007, at 1:41 PM, bsd_news wrote: 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

Re: LC_COLLATE and PostgreSQL

2007-06-24 Thread Philip Guenther
On 6/24/07, bsd_news [EMAIL PROTECTED] wrote: ... 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. ... I do not know is there possibility to fix this problem - maybe OpenBSD now support only C and