Re: LC_COLLATE

In the meantime i managed it to compile Postgresql with icu-support. Though Postgresql is still not able to *create* a database with "de_DE.UTF"-collation. So the icu-workaround is useless for database-creation with other lc_collations. So much ado about nothing ... -- View this message in

Re: LC_COLLATE

But when i type "locale -a" i get: ... de_AT.ISO8859-1 de_AT.ISO8859-15 de_AT.UTF-8 de_CH.ISO8859-1 de_CH.ISO8859-15 de_CH.UTF-8 de_DE.ISO8859-1 de_DE.ISO8859-15 de_DE.UTF-8 el_GR.ISO8859-7 el_GR.UTF-8 ... So the locale "de_DE.UTF-8" exist. What goes wrong? -- View this message in context:

Re: LC_COLLATE

On Sun, Nov 08, 2015 at 06:29:22AM -0700, bluesun08 wrote: > "OpenBSD doesn't provide LC_COLLATE locales. " ? > > We are in 2015 and i thought OpenBSD is a up-to-date server operating > system. > So OpenBSD is not recommended for practical use or a postgresql datab

Re: LC_COLLATE

TF-8 > el_GR.ISO8859-7 > el_GR.UTF-8 > ... > > So the locale "de_DE.UTF-8" exist. What goes wrong? These are LC_CTYPE. OpenBSD doesn't provide LC_COLLATE locales. There is an optional patch in FreeBSD ports that provides partial support which may be possible to adapt,

Re: LC_COLLATE

"OpenBSD doesn't provide LC_COLLATE locales. " ? We are in 2015 and i thought OpenBSD is a up-to-date server operating system. So OpenBSD is not recommended for practical use or a postgresql database server. No wonder that most professional users switch to linux. No harm meant!

Re: LC_COLLATE

I beg your pardon - i was cynical! Back to the problem: I think OpenBSD need a patch for PostgreSQL that uses ICU, like this one for FreeBSD (because i don't know how to do it manually): http://people.freebsd.org/~girgen/postgresql-icu/README.html -- View this message in context:

Re: LC_COLLATE

On 2015-11-08, bluesun08 <nans_na...@yahoo.de> wrote: > "OpenBSD doesn't provide LC_COLLATE locales. " ? > > We are in 2015 and i thought OpenBSD is a up-to-date server operating > system. > So OpenBSD is not recommended for practical use or a postgresql datab

Re: LC_COLLATE

Don't insult other people on the mailing list. -- SCCS, the source motel! Programs check in and never check out! -- Ken Thompson

Re: LC_COLLATE

On 2015-11-08 13.28.32 -0700, bluesun08 wrote: > Back to the problem: I think OpenBSD need a patch for PostgreSQL To get it into ports, send your patch to po...@openbsd.org and CC the database/postgresql maintainer (Pierre-Emmanuel Andre ). Please upstream your patch, too.

Re: LC_COLLATE

On Sun, Nov 08, 2015 at 04:03:05AM -0700, bluesun08 wrote: > But when i type "locale -a" i get: > ... > de_AT.ISO8859-1 > de_AT.ISO8859-15 > de_AT.UTF-8 > de_CH.ISO8859-1 > de_CH.ISO8859-15 > de_CH.UTF-8 > de_DE.ISO8859-1 > de_DE.ISO8859-15 > de_DE.UTF-8 > el_GR.ISO8859-7 > el_GR.UTF-8 > ... > >

Re: LC_COLLATE

> So OpenBSD is not recommended for practical use or a postgresql database > server. > No wonder that most professional users switch to linux. > > No harm meant! You are retard, go away and don't return then. j.

Re: LC_COLLATE

On Sat, Nov 7, 2015 at 9:58 AM, bluesun08 <nans_na...@yahoo.de> wrote: > for my postgresql-server i need: > LC_COLLATE="de_DE.UTF-8" > > But the following command in the .profile don't work: > export LC_COLLATE="de_DE.UTF-8" > > Why not? How can i

LC_COLLATE

Hi, for my postgresql-server i need: LC_COLLATE="de_DE.UTF-8" But the following command in the .profile don't work: export LC_COLLATE="de_DE.UTF-8" Why not? How can i do this? Regards Alex -- View this message in context: http://openbsd-archive.7691.n7.nabble.com/LC-C

Re: LC_COLLATE

ok. sorry. the real problem: i have a windows application which needs a postgresql-database with "de_DE.UTF-8" collation. When i try to create such a database in openbsd i get the error: initdb: invalid locale name "de_DE.UTF-8" When i try to create the collation in postgres, i get the

Re: LC_COLLATE

> initdb: invalid locale name "de_DE.UTF-8" > > When i try to create the collation in postgres, i get the following error: > postgres=# CREATE COLLATION german (LOCALE = 'de_DE.utf8'); > ERROR: nondefault collations are not supported on this platform OpenBSD doesn't

Re: LC_COLLATE

Thank you. I try in /etc/login.conf: postgres:\ :lang=de_DE.UTF-8:\ :setenv=LC_COLLATE=de_DE.UTF-8:\ :tc=default: After the command "initdb --lc-collate=de_DE.UTF-8 -D /var/postgresql/data" i get the following err

Re: LC_COLLATE

On Sat, Nov 7, 2015 at 1:15 PM, bluesun08 <nans_na...@yahoo.de> wrote: > Thank you. I try in /etc/login.conf: > > postgres:\ > :lang=de_DE.UTF-8:\ > :setenv=LC_COLLATE=de_DE.UTF-8:\ > :tc=default: > > After the command "initdb --lc-col

Re: LC_COLLATE and PostgreSQL

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

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

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

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

Re: LC_COLLATE and PostgreSQL

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 POSIX collation ? Your guess is correct: OpenBSD only supports the default locale, C. To quote

Re: LC_COLLATE and PostgreSQL

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

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

Re: LC_COLLATE and PostgreSQL

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 --locale

Re: LC_COLLATE and PostgreSQL

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