posgresql 8.0 RC1 missing schemas - Mailing list pgsql-bugs
From | Zsolt Pfiszter |
---|---|
Subject | posgresql 8.0 RC1 missing schemas |
Date | |
Msg-id | OFF80A90B5.8CE9DED9-ONC1256F6C.00438E02-C1256F6D.0048FD93@hu.ibm.com Whole thread Raw |
Responses |
Re: posgresql 8.0 RC1 missing schemas
|
List | 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=3D# 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=3D# 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=E1ria Informatika Ltd. 33-35, J=E1sz utca Budapest H-1135 Hungary Phone:(36 1) 412 4864 Mobile: (36) 20 8234864 Fax: (36 1) 412 4800 e-mail(IBM): <mailto:zsolt.pfiszter@hu.ibm.com> web: <http://www.isc-hungaria.hu/>
pgsql-bugs by date: