Zsolt Pfiszter <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings