From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 30998 invoked by alias); 21 May 2003 13:19:58 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 30973 invoked from network); 21 May 2003 13:19:57 -0000 Received: from unknown (HELO touchme.toronto.redhat.com) (207.219.125.105) by sources.redhat.com with SMTP; 21 May 2003 13:19:57 -0000 Received: from redhat.com (tooth.toronto.redhat.com [172.16.14.29]) by touchme.toronto.redhat.com (Postfix) with ESMTP id D8991800021; Wed, 21 May 2003 09:19:56 -0400 (EDT) Message-ID: <3ECB7C37.8020102@redhat.com> Date: Wed, 21 May 2003 13:19:00 -0000 From: Fernando Nasser Organization: Red Hat Canada User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020607 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Benilton de Sa Carvalho Cc: rhdb@sources.redhat.com Subject: Re: Red Hat Database 3.0 References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-SW-Source: 2003-q2/txt/msg00033.txt.bz2 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