Re: Red Hat Database 3.0

[Fernando Nasser <fnasser at redhat dot com>]

Benilton de Sa Carvalho wrote:
> Hi all,
>
> I downloaded the beta version of RHDB 3.0.
>
> I started using it yesterday and I think that under the "Databases" option
> there were two databases "template1" and "regression". Well, today the
> "regression" database doesn't exist (I guess I dropped it) and I'm not
> able to create tables.
>
> Under the database name there were a lot of options and now there are only
> Languages, Casts and Schemas options. Aren't other options missing? Such
> as "tables", "aggregate", etc??? Why did it happen? Did it happen because
> I erased "regression" database? Where are the databases stored on my
> system?
>
> Please, forgive me for so many questions.

It is OK Benilton, there was a major addition to the hierarchy of 
database objects in PostgreSQL.  Now we support SQL-Schemas, which can 
be thought of as a collection of tables and other elements, somewhat 
similar to a namespace with its own access privileges.

A database now has several "schemas".  The system tables and several 
other system objects now reside in the "pg_catalog" schema.  The tables 
of old-style (non-SQL-Schemas) databases as well as newly created ones 
that are not schema-qualified go into the schema "public".

If you expand the Schemas node and the public node under it you will 
find your tables.

Things have been designed so that if you don't want to use SQL-Schemas 
or is using an old database your sql scripts and programs will work as 
before.  The new manuals describe the SQL-Schemas facility in detail.

Regards,
Fernando



--
Fernando Nasser
Red Hat Canada Ltd.                     E-Mail:  fnasser@redhat.com
2323 Yonge Street, Suite #300
Toronto, Ontario   M4P 2C9