Re: [gnome-db] Minor API change and MySQL [update/delete]_row

[Rodrigo Moya <rodrigo gnome-db org>]

On Thu, 2003-10-30 at 14:40, Laurent Sansonetti wrote:
> On Thu, 2003-10-30 at 10:22, Rodrigo Moya wrote:
> > with postgres, it's possible to be notified when a table changes. You
> > register to the change notifications and every time the table you are
> > listening to changes, you get a notification.
> 
> Good point, I suppose you mean triggers.
> 
> I saw there are mentioned in gda-postgres, but not yet implemented.
> 
> I was wondering a few days ago how to use universal triggers in libgda
> (afaik, there are triggers in oracle as well).
> 
> Maybe by adding some meaningful GLib signal to GdaConnection (such as
> '[before|after]_table_[insert|delete|update])?
> 
> It would be really cool to implement triggers in libgda ;-)
>
yes, really really cool! The signal stuff in GdaConnection might be a
good way to do it. Although we have to think about the possibility of
the callback affecting the database. That is, some triggers are
'executed' before a row is inserted in the database. In those cases, the
app is able to modify the data being inserted. So, we should support
that also.

It needs a lot of thinking though, but it is a very great idea.

cheers