Re: posgresql 8.0 RC1 missing schemas

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