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 conte
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. There's an extensive FA
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:
http://ope
Don't insult other people on the mailing list.
--
SCCS, the source motel! Programs check in and never check out!
-- Ken Thompson
On 2015-11-08, 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 database
> server.
I do
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
> 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.
"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 me
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, see https://wiki.postgresq
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
> ...
>
>
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:
ht
> 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
OpenBS
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 followin
On Sat, Nov 7, 2015 at 1:15 PM, bluesun08 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-collate=de_DE.UTF-8 -D /var
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
On Sat, Nov 7, 2015 at 9:58 AM, bluesun08 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 do this?
.profile is
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
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
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 C/
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 with
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 c
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 P
SQL 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
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
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
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
26 matches
Mail list logo
