Re: posgresql 8.0 RC1 missing schemas

Dear Tom, and Michael!

Thanks in advance your help!

I tried to initdb again, but problem isn't ok.

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_toad is missing ?

If I generate schemas on my PC and copy to our S390, it will OK? ...
Workaround ...


Zsolt Pfiszter




             Tom Lane
             <tgl@sss.pgh.pa.u
             s>                                                         To
                                       Michael Fuhr <mike@fuhr.org>
             2004.12.18 06:00                                           cc
                                       Zsolt Pfiszter/Hungary/IBM@IBMHU,
                                       pgsql-bugs@postgresql.org
                                                                   Subject
                                       Re: [BUGS] posgresql 8.0 RC1
                                       missing schemas










Michael Fuhr <mike@fuhr.org> writes:
> On Fri, Dec 17, 2004 at 12:06:01PM -0500, Tom Lane wrote:
>> Zsolt Pfiszter <zsolt.pfiszter@hu.ibm.com> writes:
>>> We have compiled 8.0 RC1 on SLES 7.0 S/390 2.2.16 kernel, gcc version:
>>> 2.95.2
>>> We run initdb command without error. It created a DB directory
structure,
>>> but didn't create some schemas in template1.
>>
>> Hmm, somebody reported something similar a couple days ago, but the
>> report was sufficiently confused that I kinda thought it was pilot error
>> of some sort.  No, we don't know what's going on ...

> Both people reporting the problem appear to be in Hungary.  Coincidence?

My, that's an interesting point.  Zsolt, what locale are you running
initdb under?  Does the problem go away if you do it in C locale?

                                     regards, tom lane