From: Fernando Nasser <fnasser@redhat.com>
To: Paul Leung <dragonpath@hotmail.com>
Cc: overholt@redhat.com, dbhole@redhat.com, rhdb@sources.redhat.com
Subject: Re: RHDB 2.1 ISO not working
Date: Sun, 12 Jan 2003 17:40:00 -0000 [thread overview]
Message-ID: <3E21AD3A.9070109@redhat.com> (raw)
In-Reply-To: <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
next prev parent reply other threads:[~2003-01-12 17:40 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2003-01-12 5:48 Paul Leung
2003-01-12 17:40 ` Fernando Nasser [this message]
2003-01-13 16:49 ` Patrick Macdonald
-- strict thread matches above, loose matches on Subject: below --
2003-01-10 6:19 Paul Leung
2003-01-10 5:43 Paul Leung
2003-01-10 15:24 ` Andrew Overholt
2003-01-09 21:55 Fred New
2003-01-09 13:58 George T. Gibson
2003-01-09 4:33 Paul Leung
2003-01-09 18:19 ` Deepak Bhole
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=3E21AD3A.9070109@redhat.com \
--to=fnasser@redhat.com \
--cc=dbhole@redhat.com \
--cc=dragonpath@hotmail.com \
--cc=overholt@redhat.com \
--cc=rhdb@sources.redhat.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).