Red Hat Database 3.0

Red Hat Database 3.0

[Benilton de Sa Carvalho]

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.

Best regards,

Benilton

Re: Red Hat Database 3.0

[Fernando Nasser]

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

Re: Red Hat Database 3.0

[Benilton de Sa Carvalho]

Hi Fernando,

thank you for your help. Thank you very much.

I found the tables node. I tried to add a simple table with "id" and
"nome" columns. But I had the following error:

The backend returned the error:
ERROR: cannot create
pg_catalog.dados_pessoais_id_seq: system
catalog modifications are currently disallowed


Could you please help me on this matter?

Best wishes,
Benilton

Re: Red Hat Database 3.0

[Fernando Nasser]

Benilton de Sa Carvalho wrote:
> Hi Fernando,
> 
> thank you for your help. Thank you very much.
> 
> I found the tables node. I tried to add a simple table with "id" and
> "nome" columns. But I had the following error:
> 
> The backend returned the error:
> ERROR: cannot create
> pg_catalog.dados_pessoais_id_seq: system
> catalog modifications are currently disallowed
> 
> 
> Could you please help me on this matter?
> 

Hi Benilton.

Under which schema are you trying to create your table?  The pg_catalog schema 
is for use by the DBMS only.  You need to create your tables under the 'public' 
schema or create your own schema and put your tables in it.  If you don't need 
SQL-Schemas I would recommend you just use the public schema.

Give it a try.


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