Re: [gnome-db] Congratulations to you all -> PostgreSQL 7.3 questions

[Rodrigo Moya <rodrigo gnome-db org>]

On Fri, 2002-12-13 at 10:03, Jean-Michel POURE wrote:
> Le Vendredi 13 Décembre 2002 09:44, Vivien Malerba a écrit :
> > The first thing you could focus on is define :
> > - what the functions editor will allow the user to do,
> > - in which way it is generic for other DBMS (I know Oracle does also
> >   support it) and define optional features for each DBMS
> > - using glade, propose a GUI for the functions editor (for example we
> >   could add a page in the main mergeant window to show user defined
> >   functions and from there the user could open a dialog window to edit
> >   or create new functions).
> 
> Also, we need to support triggers in libgda.
>
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-PROVIDER-GET-SCHEMA)

Once we've got that list, I'll add it to the documentation and start
implemnenting the schema in the providers.

>  Functions are mostly triggered, 
>
well, a lot of are triggered, but not always. I used to have stored
procedures in a Oracle database that contained the data management logic
(updates to many tables at once) and used to call them mainly from Pro*C
programs. I suppose a lot of people use them in this way.

Also, think that sometimes people use stored procedures functions to
contain calculations, and return a result. for instance, a calculateVAT
procedure, that can be used in a SELECT, INSERT, UPDATE, etc statement.

So, I don't think triggers are the main use of functions. Although, of
course, we really want to also support triggers. I've created a bug:

http://bugzilla.gnome.org/show_bug.cgi?id=101121

for this issue. Please add any comments (the fields list, etc) to it.

cheers