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