From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Received: (qmail 1279 invoked from network); 12 Jan 2003 17:40:44 -0000 Received: from unknown (HELO touchme.toronto.redhat.com) (216.138.202.10) by 209.249.29.67 with SMTP; 12 Jan 2003 17:40:44 -0000 Received: from redhat.com (tooth.toronto.redhat.com [172.16.14.29]) by touchme.toronto.redhat.com (Postfix) with ESMTP id 3C9AA800041; Sun, 12 Jan 2003 12:40:32 -0500 (EST) Message-ID: <3E21AD3A.9070109@redhat.com> Date: Sun, 12 Jan 2003 17:40: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: Paul Leung Cc: overholt@redhat.com, dbhole@redhat.com, rhdb@sources.redhat.com Subject: Re: RHDB 2.1 ISO not working References: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-SW-Source: 2003-q1/txt/msg00016.txt.bz2 Paul Leung wrote: > I created a database cluster in one account with the admin program. > When I went into another account and opened up the admin program, the > database cluster wasnt there. The admin program had no clusters shown > initially. I manually added the cluster that I made with my other > account but I wasnt sure if it was the same cluster that I made > initially or a brand new cluster that has the same name as the first > one. So what's happening here? > A RHDB/PostgreSQL cluster is defined by a DBMS backend listening on a certain port of a certain host. As long as you defined the new cluster with the same host name (or IP address) and port number you are connecting to the same database cluster (or "catalog cluster" in the SQL standard terms -- I find the PostgreSQL terminology more clear). Of course you can also choose what database user you want to connect as, so you can have different "clusters" so you can connect as the DBA or as an ordinary user to the same backend. Anyway, each user of the tool may want these things set differently, connect to different clusters etc., so these settings are per Unix user and sored in the ~/.rhdb directory. > I also noticed that there was a trigger tab that I could go to to add > triggers. I saw tabs for views, functions, and etc. but nothing for > triggers. Where do I go to add triggers? Triggers are database objects associated with tables. If you open a table node (after you create a table, of course), you will see things like indexes and triggers in there. Regards, Fernando -- Fernando Nasser Red Hat Canada Ltd. E-Mail: fnasser@redhat.com 2323 Yonge Street, Suite #300 Toronto, Ontario M4P 2C9