Re: posgresql 8.0 RC1 missing schemas

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Zsolt Pfiszter <zsolt(dot)pfiszter(at)hu(dot)ibm(dot)com> writes:
> our enviroment settings:

> postgres# locale
> LANG=hungarian
> LC_CTYPE="hungarian"
> LC_NUMERIC="hungarian"
> LC_TIME="hungarian"
> LC_COLLATE=POSIX
> LC_MONETARY="hungarian"
> LC_MESSAGES="hungarian"
> LC_ALL=

> template1=# select * from pg_namespace;
>       nspname       | nspowner |               nspacl
> --------------------+----------+-------------------------------------
>  pg_catalog         |        1 | {postgres=UC/postgres,=U/postgres}
>  public             |        1 | {postgres=UC/postgres,=UC/postgres}
>  information_schema |        1 | {postgres=UC/postgres,=U/postgres}

> I think pg_toast is missing ?

It sure is, and I'd expect pg_temp_1 to exist as well after initdb.
Weird.

I tried to reproduce this on a machine I have access to, namely an S390
at Red Hat (running RHEL 3AS Update 3).  Everything works just fine
so far as I can tell with those locale settings.  I even cheated and
said "initdb -E unicode" which isn't compatible with this locale ---
initdb gave me a stern warning, and I'm pretty sure sorting of non-ASCII
data wouldn't work well, but it got through initdb and those schemas
were there.

I'm guessing that the problem is specific to the SLES 7 environment.
That release is a bit old isn't it?  We might be looking at some weird
compiler bug, or perhaps a problem with the hungarian locale definition.

			regards, tom lane