From: Fernando Nasser <fnasser@redhat.com>
To: Benilton de Sa Carvalho <carvalho@ime.unicamp.br>
Cc: rhdb@sources.redhat.com
Subject: Re: Red Hat Database 3.0
Date: Wed, 21 May 2003 13:19:00 -0000 [thread overview]
Message-ID: <3ECB7C37.8020102@redhat.com> (raw)
In-Reply-To: <Pine.GSO.4.10.10305211000450.26471-100000@athenas.ime.unicamp.br>
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
next prev parent reply other threads:[~2003-05-21 13:19 UTC|newest]
Thread overview: 4+ messages / expand[flat|nested] mbox.gz Atom feed top
2003-05-21 13:10 Benilton de Sa Carvalho
2003-05-21 13:19 ` Fernando Nasser [this message]
2003-05-21 13:45 Benilton de Sa Carvalho
2003-05-21 15:33 ` Fernando Nasser
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=3ECB7C37.8020102@redhat.com \
--to=fnasser@redhat.com \
--cc=carvalho@ime.unicamp.br \
--cc=rhdb@sources.redhat.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).