public inbox for rhdb@sourceware.org
 help / color / mirror / Atom feed
* Re: Red Hat Database 3.0
@ 2003-05-21 13:45 Benilton de Sa Carvalho
  2003-05-21 15:33 ` Fernando Nasser
  0 siblings, 1 reply; 4+ messages in thread
From: Benilton de Sa Carvalho @ 2003-05-21 13:45 UTC (permalink / raw)
  To: rhdb

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


^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Red Hat Database 3.0
  2003-05-21 13:45 Red Hat Database 3.0 Benilton de Sa Carvalho
@ 2003-05-21 15:33 ` Fernando Nasser
  0 siblings, 0 replies; 4+ messages in thread
From: Fernando Nasser @ 2003-05-21 15:33 UTC (permalink / raw)
  To: Benilton de Sa Carvalho; +Cc: rhdb

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

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Re: Red Hat Database 3.0
  2003-05-21 13:10 Benilton de Sa Carvalho
@ 2003-05-21 13:19 ` Fernando Nasser
  0 siblings, 0 replies; 4+ messages in thread
From: Fernando Nasser @ 2003-05-21 13:19 UTC (permalink / raw)
  To: Benilton de Sa Carvalho; +Cc: rhdb

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

^ permalink raw reply	[flat|nested] 4+ messages in thread

* Red Hat Database 3.0
@ 2003-05-21 13:10 Benilton de Sa Carvalho
  2003-05-21 13:19 ` Fernando Nasser
  0 siblings, 1 reply; 4+ messages in thread
From: Benilton de Sa Carvalho @ 2003-05-21 13:10 UTC (permalink / raw)
  To: rhdb

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

^ permalink raw reply	[flat|nested] 4+ messages in thread

end of thread, other threads:[~2003-05-21 15:33 UTC | newest]

Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2003-05-21 13:45 Red Hat Database 3.0 Benilton de Sa Carvalho
2003-05-21 15:33 ` Fernando Nasser
  -- strict thread matches above, loose matches on Subject: below --
2003-05-21 13:10 Benilton de Sa Carvalho
2003-05-21 13:19 ` Fernando Nasser

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).