Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] upper and lower doesn't work with german

From: Vincent(dot)Gaboriau(at)answare(dot)fr
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [HACKERS] upper and lower doesn't work with german
Date: 2001-11-28 16:29:51
Message-ID: 3C0510FF.694D34EA@answare.fr (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-novice

Tom Lane a écrit :

> Vincent(dot)Gaboriau(at)answare(dot)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!


In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2001-11-28 16:35:29
Subject: Re: [HACKERS] upper and lower doesn't work with german
Previous:From: Tom LaneDate: 2001-11-28 15:11:05
Subject: Re: [HACKERS] upper and lower doesn't work with german

pgsql-hackers by date

Next:From: Tom LaneDate: 2001-11-28 16:31:15
Subject: Re: Sequence docs
Previous:From: Tom LaneDate: 2001-11-28 16:23:04
Subject: Re: FW: [ppa-dev] Severe bug in debian - phppgadmin opens up

pgsql-admin by date

Next:From: Tom LaneDate: 2001-11-28 16:35:29
Subject: Re: [HACKERS] upper and lower doesn't work with german
Previous:From: Vincent.GaboriauDate: 2001-11-28 16:24:14
Subject: éèàïîù Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group