pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedupper and lower doesn't work with german umlaut?
20+ messages / 7 participants
[nested] [flat]
* upper and lower doesn't work with german umlaut?
@ 2001-11-21 14:15 "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-23 21:57 ` Re: upper and lower doesn't work with german umlaut? Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 20+ messages in thread
From: "König, Frank" @ 2001-11-21 14:15 UTC (permalink / raw)
To: 'pgsql-novice@postgresql.org' <pgsql-novice@postgresql.org>; pgsql-admin; 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
hello, what is wrong?
postgresql 7.1.3
suse linux 7.1
configure postgresql:
./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST
--enable-local --enable-multibyte
--enable-odbc --enable-syslog --with-java
init database:
$DIR_DEST/bin/initdb --pgdata=$DIR_DB01 --encoding=LATIN1
check LANG-variable:
postgres@server:/app/pgsql/bin > echo $LANG
de_DE
and that's the result:
my_db=# select lower('ÄäÜüÖöß');
lower
---------
ÄäÜüÖöß
(1 row)
uppercase umlauts are not converted.
thanks
frank
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german umlaut?
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
@ 2001-11-23 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
1 sibling, 1 reply; 20+ messages in thread
From: Tom Lane @ 2001-11-23 16:43 UTC (permalink / raw)
To: "König, Frank" <Frank.Koenig@rossmann.de>; +Cc: 'pgsql-novice@postgresql.org' <pgsql-novice@postgresql.org>; pgsql-admin; 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
=?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> uppercase umlauts are not converted.
Did you run initdb with the correct LANG environment?
To check, run contrib/pg_controldata and see what it says about
LC_COLLATE and LC_CTYPE.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german umlaut?
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-27 08:42 ` Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
0 siblings, 1 reply; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-27 08:42 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Tom Lane a écrit :
> =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> > uppercase umlauts are not converted.
>
> Did you run initdb with the correct LANG environment?
>
> To check, run contrib/pg_controldata and see what it says about
> LC_COLLATE and LC_CTYPE.
I have relativily the same problem! Where can I find the executable "contrib"
?
Thanks!
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
@ 2001-11-27 15:43 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
0 siblings, 1 reply; 20+ messages in thread
From: Stephan Szabo @ 2001-11-27 15:43 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
On Tue, 27 Nov 2001 Vincent.Gaboriau@answare.fr wrote:
>
> Tom Lane a écrit :
>
> > =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> > > uppercase umlauts are not converted.
> >
> > Did you run initdb with the correct LANG environment?
> >
> > To check, run contrib/pg_controldata and see what it says about
> > LC_COLLATE and LC_CTYPE.
>
> I have relativily the same problem! Where can I find the executable "contrib"
> ?
contrib refers to the contrib directory at the top level of the source
tree.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
@ 2001-11-27 16:08 ` Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 17:34 ` Re: [HACKERS] upper and lower doesn't work with german Andrew G. Hammond <drew@xyzzy.dhs.org>
0 siblings, 2 replies; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-27 16:08 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Stephan Szabo a écrit :
> On Tue, 27 Nov 2001 Vincent.Gaboriau@answare.fr wrote:
>
> >
> > Tom Lane a écrit :
> >
> > > =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> > > > uppercase umlauts are not converted.
> > >
> > > Did you run initdb with the correct LANG environment?
> > >
> > > To check, run contrib/pg_controldata and see what it says about
> > > LC_COLLATE and LC_CTYPE.
> >
> > I have relativily the same problem! Where can I find the executable "contrib"
> > ?
>
> contrib refers to the contrib directory at the top level of the source
> tree.
>
The sources of postgres have been deleted, so I can't find this "contrib"!
So I surch another way to know if postgres have been installed with the local
configuration.
Can anyone help me?
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-27 16:57 ` Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
1 sibling, 1 reply; 20+ messages in thread
From: Stephan Szabo @ 2001-11-27 16:57 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
On Tue, 27 Nov 2001 Vincent.Gaboriau@answare.fr wrote:
>
>
> Stephan Szabo a écrit :
>
> > On Tue, 27 Nov 2001 Vincent.Gaboriau@answare.fr wrote:
> >
> > >
> > > Tom Lane a écrit :
> > >
> > > > =?ISO-8859-1?Q?=22K=F6nig=2C_Frank=22?= <Frank.Koenig@rossmann.de> writes:
> > > > > uppercase umlauts are not converted.
> > > >
> > > > Did you run initdb with the correct LANG environment?
> > > >
> > > > To check, run contrib/pg_controldata and see what it says about
> > > > LC_COLLATE and LC_CTYPE.
> > >
> > > I have relativily the same problem! Where can I find the executable "contrib"
> > > ?
> >
> > contrib refers to the contrib directory at the top level of the source
> > tree.
> >
>
> The sources of postgres have been deleted, so I can't find this "contrib"!
> So I surch another way to know if postgres have been installed with the local
> configuration.
> Can anyone help me?
You might be able to get it by looking through the
<data dir>/global/pg_control file, but it's a binary file so you'll have
to search for it.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
@ 2001-11-28 08:37 ` Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-28 08:37 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
> > The sources of postgres have been deleted, so I can't find this "contrib"!
> > So I surch another way to know if postgres have been installed with the local
> > configuration.
> > Can anyone help me?
>
> You might be able to get it by looking through the
> <data dir>/global/pg_control file, but it's a binary file so you'll have
> to search for it.
I had found it, but I don't know speak fluent binary language ;-)
Does a way exist to "decompile" it or to get informations on it?
Thanks.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-28 15:11 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
0 siblings, 1 reply; 20+ messages in thread
From: Tom Lane @ 2001-11-28 15:11 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
Vincent.Gaboriau@answare.fr writes:
>> You might be able to get it by looking through the
>> <data dir>/global/pg_control file, but it's a binary file so you'll have
>> to search for it.
> I had found it, but I don't know speak fluent binary language ;-)
> Does a way exist to "decompile" it or to get informations on it?
If you can't be troubled to compile up pg_controldata, then you'll
have to resort to good old od:
$ od -c pg_control
0000000 314 201 030 267 255 u 344 277 \0 \0 \0 G 013 355 p 253
0000020 \0 \0 \0 004 < 004 ) 006 \0 \0 \0 \0 \0 \0 \0 8
0000040 \0 \0 \0 \0 7 026 e 210 \0 \0 \0 \0 7 026 D h
0000060 \0 \0 \0 \0 7 026 e 210 \0 \0 \0 \0 \0 \0 \0 \0
0000100 \0 \0 \0 \t \0 001 357 235 \0 017 017 354 < 004 ) 004
0000120 \0 \0 \0 \0 002 \0 \0 C \0 \0 \0 \0 \0 \0 \0
0000140 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
*
0000320 \0 \0 \0 \0 \0 \0 \0 \0 C \0 \0 \0 \0 \0 \0 \0
0000340 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
*
0020000
The LC_COLLATE and LC_CTYPE locale strings should be the last nonzero
things in the file --- they're both "C" in this example.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-28 16:29 ` Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-28 16:29 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom Lane a écrit :
> Vincent.Gaboriau@answare.fr writes:
> >> You might be able to get it by looking through the
> >> <data dir>/global/pg_control file, but it's a binary file so you'll have
> >> to search for it.
>
> > I had found it, but I don't know speak fluent binary language ;-)
> > Does a way exist to "decompile" it or to get informations on it?
>
> If you can't be troubled to compile up pg_controldata, then you'll
> have to resort to good old od:
>
> $ od -c pg_control
> 0000000 314 201 030 267 255 u 344 277 \0 \0 \0 G 013 355 p 253
> 0000020 \0 \0 \0 004 < 004 ) 006 \0 \0 \0 \0 \0 \0 \0 8
> 0000040 \0 \0 \0 \0 7 026 e 210 \0 \0 \0 \0 7 026 D h
> 0000060 \0 \0 \0 \0 7 026 e 210 \0 \0 \0 \0 \0 \0 \0 \0
> 0000100 \0 \0 \0 \t \0 001 357 235 \0 017 017 354 < 004 ) 004
> 0000120 \0 \0 \0 \0 002 \0 \0 C \0 \0 \0 \0 \0 \0 \0
> 0000140 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> *
> 0000320 \0 \0 \0 \0 \0 \0 \0 \0 C \0 \0 \0 \0 \0 \0 \0
> 0000340 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> *
> 0020000
>
> The LC_COLLATE and LC_CTYPE locale strings should be the last nonzero
> things in the file --- they're both "C" in this example.
>
Thanks to Tom Lane!
But I have This in my pg_control file:
# od -c pg_control
0000000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0
0000020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0
0000040 ± Õ ë \v \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
0000060 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
*
0020000
#
So no LC_COLLATE and LC_TYPE in the pg_control. But these variables are set in
the user environement!
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-28 16:35 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
0 siblings, 1 reply; 20+ messages in thread
From: Tom Lane @ 2001-11-28 16:35 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
Vincent.Gaboriau@answare.fr writes:
> But I have This in my pg_control file:
> # od -c pg_control
> 0000000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0
> 0000020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0
> 0000040 ± Õ ë \v \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> 0000060 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> *
> 0020000
> #
Er ... *what* version did you say you were running? That doesn't look
like a 7.1 pg_control to me.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-28 16:44 ` Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-28 16:44 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom Lane a écrit :
> Vincent.Gaboriau@answare.fr writes:
> > But I have This in my pg_control file:
>
> > # od -c pg_control
> > 0000000 \0 \0 \0 \0 001 \0 \0 \0 \0 \0 \0 \0 \b \0 \0 \0
> > 0000020 ¤ 006 004 < 004 \0 \0 \0 \0 \0 \0 \0 \0 002 \0
> > 0000040 ± Õ ë \v \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> > 0000060 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0 \0
> > *
> > 0020000
> > #
>
> Er ... *what* version did you say you were running? That doesn't look
> like a 7.1 pg_control to me.
No, I have an 7.0.2 on Linux Mandrake 7.2.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-28 17:13 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 09:01 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
0 siblings, 1 reply; 20+ messages in thread
From: Tom Lane @ 2001-11-28 17:13 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
Vincent.Gaboriau@answare.fr writes:
>> Er ... *what* version did you say you were running? That doesn't look
>> like a 7.1 pg_control to me.
> No, I have an 7.0.2 on Linux Mandrake 7.2.
Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at
initdb, which means that you can corrupt your indexes by starting the
postmaster with different LC settings at different times. Which is
depressingly easy to do.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-29 09:01 ` Vincent.Gaboriau@answare.fr
2001-11-29 14:24 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-29 09:01 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom Lane a écrit :
> Vincent.Gaboriau@answare.fr writes:
> >> Er ... *what* version did you say you were running? That doesn't look
> >> like a 7.1 pg_control to me.
>
> > No, I have an 7.0.2 on Linux Mandrake 7.2.
>
> Time to update then. 7.0 doesn't freeze the LC_COLLATE setting at
> initdb, which means that you can corrupt your indexes by starting the
> postmaster with different LC settings at different times. Which is
> depressingly easy to do.
Ok! And does the new version correct my character sequences error?
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 09:01 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-29 14:24 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 14:43 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-29 15:06 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 20+ messages in thread
From: Tom Lane @ 2001-11-29 14:24 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
Vincent.Gaboriau@answare.fr writes:
> Ok! And does the new version correct my character sequences error?
Which was ...?
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 09:01 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-29 14:24 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-29 14:43 ` Vincent.Gaboriau@answare.fr
1 sibling, 0 replies; 20+ messages in thread
From: Vincent.Gaboriau@answare.fr @ 2001-11-29 14:43 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Tom Lane a écrit :
> Vincent.Gaboriau@answare.fr writes:
> > Ok! And does the new version correct my character sequences error?
>
> Which was ...?
Refer to " [ADMIN] character sequence problem"
Thanks for your help.
regards, Vincent.
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 09:01 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-29 14:24 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
@ 2001-11-29 15:06 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 20+ messages in thread
From: Tom Lane @ 2001-11-29 15:06 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
> Vincent.Gaboriau@answare.fr writes:
>> Ok! And does the new version correct my character sequences error?
> Which was ...?
Oh, never mind (for some reason my first search for your previous
messages didn't turn up anything).
I'm not sure. The LIKE queries you were complaining of didn't look like
they could use an index anyway, so index corruption wouldn't explain
misbehavior there. But I'd recommend updating from 7.0 to 7.1
regardless.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: [HACKERS] upper and lower doesn't work with german
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Re: [HACKERS] upper and lower doesn't work with german umlaut? Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
@ 2001-11-27 17:34 ` Andrew G. Hammond <drew@xyzzy.dhs.org>
1 sibling, 0 replies; 20+ messages in thread
From: Andrew G. Hammond @ 2001-11-27 17:34 UTC (permalink / raw)
To: Vincent.Gaboriau@answare.fr; +Cc: pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 2001 November 27 11:08 am, Vincent.Gaboriau@answare.fr wrote:
> > > > To check, run contrib/pg_controldata and see what it says about
> > > > LC_COLLATE and LC_CTYPE.
> > >
> > > I have relativily the same problem! Where can I find the executable
> > > "contrib" ?
> >
> > contrib refers to the contrib directory at the top level of the source
> > tree.
>
> The sources of postgres have been deleted, so I can't find this "contrib"!
Under debian linux, it is
/usr/lib/postgresql/bin/pg_controldata
You should be able to find it quickly using
% locate pg_controldata
Alternately, if your system isn't properly maintained (and, unless you've got
some seriously nice hardware, this will take some time: grab a coffee while
you wait...), try
% find / -name 'pg_controldata' -print 2> /dev/null
- --
Andrew G. Hammond mailto:drew@xyzzy.dhs.org http://xyzzy.dhs.org/~drew/
56 2A 54 EF 19 C0 3B 43 72 69 5B E3 69 5B A1 1F 613-389-5481
5CD3 62B0 254B DEB1 86E0 8959 093E F70A B457 84B1
"To blow recursion you must first blow recur" -- me
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iEYEARECAAYFAjwDzroACgkQCT73CrRXhLGCDgCfcWiJQWBl25oDh1qkgliH9hZz
ORIAnAtcWijMWTZXtWKWiPUorVz82GXU
=9Tyz
-----END PGP SIGNATURE-----
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: upper and lower doesn't work with german umlaut?
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
@ 2001-11-23 21:57 ` Peter Eisentraut <peter_e@gmx.net>
2001-11-24 01:56 ` Re: upper and lower doesn't work with german umlaut? Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 1 reply; 20+ messages in thread
From: Peter Eisentraut @ 2001-11-23 21:57 UTC (permalink / raw)
To: "König, Frank" <Frank.Koenig@rossmann.de>; +Cc: 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
"König, Frank" writes:
> ./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST
> --enable-local --enable-multibyte
^^^^^
locale
> --enable-odbc --enable-syslog --with-java
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: upper and lower doesn't work with german umlaut?
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 21:57 ` Re: upper and lower doesn't work with german umlaut? Peter Eisentraut <peter_e@gmx.net>
@ 2001-11-24 01:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-11-24 03:45 ` Re: upper and lower doesn't work with german umlaut? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 20+ messages in thread
From: Bruce Momjian @ 2001-11-24 01:56 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: "König, Frank" <Frank.Koenig@rossmann.de>; 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
> "K?nig, Frank" writes:
>
> > ./configure --prefix=$DIR_DEST --exec-prefix=$DIR_DEST
> > --enable-local --enable-multibyte
> ^^^^^
> locale
>
> > --enable-odbc --enable-syslog --with-java
And why does configure ignore flags it doesn't support. I sure don't
like that.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 20+ messages in thread
* Re: upper and lower doesn't work with german umlaut?
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 21:57 ` Re: upper and lower doesn't work with german umlaut? Peter Eisentraut <peter_e@gmx.net>
2001-11-24 01:56 ` Re: upper and lower doesn't work with german umlaut? Bruce Momjian <pgman@candle.pha.pa.us>
@ 2001-11-24 03:45 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 20+ messages in thread
From: Tom Lane @ 2001-11-24 03:45 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: Peter Eisentraut <peter_e@gmx.net>; "König, Frank" <Frank.Koenig@rossmann.de>; 'pgsql-hackers@postgresql.org' <pgsql-hackers@postgresql.org>
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> And why does configure ignore flags it doesn't support. I sure don't
> like that.
Complain to the GNU people. I've always considered this a serious bug
in autoconf, but they steadfastly maintain it's a feature.
regards, tom lane
^ permalink raw reply [nested|flat] 20+ messages in thread
end of thread, other threads:[~2001-11-29 15:06 UTC | newest]
Thread overview: 20+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-11-21 14:15 upper and lower doesn't work with german umlaut? "König, Frank" <Frank.Koenig@rossmann.de>
2001-11-23 16:43 ` Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 08:42 ` Vincent.Gaboriau@answare.fr
2001-11-27 15:43 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-27 16:08 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-27 16:57 ` Re: [HACKERS] upper and lower doesn't work with german Stephan Szabo <sszabo@megazone23.bigpanda.com>
2001-11-28 08:37 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 15:11 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:29 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 16:35 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-28 16:44 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-28 17:13 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 09:01 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-29 14:24 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-29 14:43 ` Re: [HACKERS] upper and lower doesn't work with german Vincent.Gaboriau@answare.fr
2001-11-29 15:06 ` Re: [HACKERS] upper and lower doesn't work with german Tom Lane <tgl@sss.pgh.pa.us>
2001-11-27 17:34 ` Re: [HACKERS] upper and lower doesn't work with german Andrew G. Hammond <drew@xyzzy.dhs.org>
2001-11-23 21:57 ` Peter Eisentraut <peter_e@gmx.net>
2001-11-24 01:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2001-11-24 03:45 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox