RE: [gnome-db] Triggers support

["Daniel Morgan" <danmorg sc rr com>]

The PostgreSQL libgda provider already gets metadata about triggers,
indexes, primary and foreign keys and their references.  Gonzalo Paniagua
Javier did the libgda2 PostgreSQL provider and can provide more details
about it.

The GnomeDbBrowser widget which was used in the old GNOME-DB frontend had
the ability to list triggers, indexes, foreign/primary keys and their
references, functions, aggregates, tables, views, sequences, databases, and
users.

Basically, libgda already has an abstract way to get various database
objects.

Somehow, this functionality needs to be taken from the GnomeDbBrowser widget
and put into Mergeant.

-----Original Message-----
From: gnome-db-list-admin gnome org
[mailto:gnome-db-list-admin gnome org]On Behalf Of Vivien Malerba
Sent: Monday, December 16, 2002 3:52 AM
To: Rodrigo Moya
Cc: jm poure freesurf fr; gnome-db-list gnome org
Subject: Re: [gnome-db] Triggers support


On Sun, Dec 15, 2002 at 02:48:30PM +0100, Rodrigo Moya wrote:
> On Fri, 2002-12-13 at 14:40, Jean-Michel POURE wrote:
> > Le Vendredi 13 Décembre 2002 14:08, Rodrigo Moya a écrit :
> > > yes. Could you please come to a list of fields that should be returned
> > > for the triggers schema? (that is, as with the other schemas
> > >
(http://www.gnome-db.org/docs/libgda/libgda-provider-class.html#LIBGDA-PROV
> > >IDER-GET-SCHEMA)
> >
> > http://www.postgresql.org/idocs/ is a good place to query PostgreSQL
> > documentation.
>
> ...
>
> coments added to the bug.
>


If you are talking about a schema for triggers (I haven't followed the
whole discussion so forgive me if I'm out of subject), can you also
think about how to get information on foreign keys and referential
integrity rules?

I know that within Postgres these two notions are implemented using
triggers, but I don't know if it is the same for other DBMS. Maybe it is
easier to have a schema request for triggers and another for foreign
keys and referential integrity rules, may be not...

What do you think?

Cheers,

Vivien
_______________________________________________
gnome-db-list mailing list
gnome-db-list gnome org
http://mail.gnome.org/mailman/listinfo/gnome-db-list