Re: posgresql 8.0 RC1 missing schemas - Mailing list pgsql-bugs

From Zsolt Pfiszter
Subject Re: posgresql 8.0 RC1 missing schemas
Date
Msg-id OF12D54162.40CBF3B8-ONC1256F6E.00338918-C1256F6E.00349972@hu.ibm.com
Whole thread Raw
In response to Re: posgresql 8.0 RC1 missing schemas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: posgresql 8.0 RC1 missing schemas
Re: posgresql 8.0 RC1 missing schemas
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Jdbc3SimpleDataSource does not require the setting of
Next
From: Michael Fuhr
Date:
Subject: Re: posgresql 8.0 RC1 missing schemas