From: | Zsolt Pfiszter <zsolt(dot)pfiszter(at)hu(dot)ibm(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | posgresql 8.0 RC1 missing schemas |
Date: | 2004-12-17 13:17:15 |
Message-ID: | OFF80A90B5.8CE9DED9-ONC1256F6C.00438E02-C1256F6D.0048FD93@hu.ibm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hi All!
Sorry, if my problem is not a bug, I've searched for a reported issue, but
I haven't found one :(
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.
I connect to template1 and
template1=# select * from pg_tables;
schemaname | tablename | tableowner | tablespace |
hasind
--------------------+-------------------------+------------+------------+-------
information_schema | sql_languages | postgres | | f
information_schema | sql_packages | postgres | | f
information_schema | sql_sizing | postgres | | f
information_schema | sql_sizing_profiles | postgres | | f
information_schema | sql_features | postgres | | f
information_schema | sql_implementation_info | postgres | | f
pg_catalog | pg_shadow | postgres | pg_global | t
pg_catalog | pg_statistic | postgres | | t
pg_catalog | pg_inherits | postgres | | t
pg_catalog | pg_index | postgres | | t
pg_catalog | pg_operator | postgres | | t
pg_catalog | pg_opclass | postgres | | t
pg_catalog | pg_am | postgres | | t
pg_catalog | pg_amop | postgres | | t
pg_catalog | pg_amproc | postgres | | t
pg_catalog | pg_language | postgres | | t
pg_catalog | pg_largeobject | postgres | | t
pg_catalog | pg_aggregate | postgres | | t
pg_catalog | pg_trigger | postgres | | t
pg_catalog | pg_listener | postgres | | f
pg_catalog | pg_cast | postgres | | t
pg_catalog | pg_namespace | postgres | | t
pg_catalog | pg_conversion | postgres | | t
pg_catalog | pg_depend | postgres | | t
pg_catalog | pg_attrdef | postgres | | t
pg_catalog | pg_constraint | postgres | | t
pg_catalog | pg_database | postgres | pg_global | t
pg_catalog | pg_description | postgres | | t
pg_catalog | pg_group | postgres | pg_global | t
pg_catalog | pg_proc | postgres | | t
pg_catalog | pg_rewrite | postgres | | t
pg_catalog | pg_type | postgres | | t
pg_catalog | pg_attribute | postgres | | t
pg_catalog | pg_class | postgres | | t
pg_catalog | pg_tablespace | postgres | pg_global | t
but
template1=# select * from pg_catalog.pg_tablespace;
ERROR: relation "pg_catalog.pg_tablespace" does not exist.
What can I do?
Is it a known or general problem?
Zsolt Pfiszter
DS System Administrator
ISC-Hungária Informatika Ltd.
33-35, Jász utca
Budapest H-1135
Hungary
Phone:(36 1) 412 4864 Mobile: (36) 20 8234864
Fax: (36 1) 412 4800
e-mail(IBM): <mailto:zsolt(dot)pfiszter(at)hu(dot)ibm(dot)com>
web: <http://www.isc-hungaria.hu/>
From | Date | Subject | |
---|---|---|---|
Next Message | Ken Johanson | 2004-12-17 15:21:24 | Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI |
Previous Message | Bruce Momjian | 2004-12-17 03:25:28 | Re: BUG #1350: Backslash ecape charcter violates ISO/ANSI spec |