This is the mail archive of the
rhdb@sources.redhat.com
mailing list for the RHDB project.
Re: RHDB 2.1 ISO not working
- From: Fernando Nasser <fnasser at redhat dot com>
- To: Paul Leung <dragonpath at hotmail dot com>
- Cc: overholt at redhat dot com, dbhole at redhat dot com, rhdb at sources dot redhat dot com
- Date: Sun, 12 Jan 2003 13:00:26 -0500
- Subject: Re: RHDB 2.1 ISO not working
- Organization: Red Hat Canada
- References: <F9874BXD65R1fL1dnB1000048d6@hotmail.com>
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