Dear Fabian,

Thank you for your quick response. For now I mainly want to see if it is possible to (1) For each newly inserted tuple in a certain relation, automatically add (some) other tuple(s) to other relations based on this insert. (2) After each elapse of a certain time-interval remove (some) tuple(s) from (some) relation(s).

Regards,

Arthur

On Thu, 2005-07-14 at 18:14, Fabian wrote:

Currently there are no triggers in MonetDB/SQL.

Niels knows if and when they will appear. What is it exactly that you want to achieve? "ON DELETE CASCADE" constructs, or more complicated "ON UPDATE EXECUTE compute_aggr()" like things?

Regards, Fabian

Arthur van Bunningen wrote:

...

Dear all,

First my compliments with this piece of useful and implemented research. Second I was wondering if there is a possibility to have so-called "triggers" in MonetDB such as in for example PostgreSQL [1] or if there are other ways to use MonetDB as an "active database".

If anyone has experiences in this field or can point me to the right place to look for this experience I would be very thankful.

Kind regards,

Arthur van Bunningen

[1] http://www.postgresql.org/docs/8.0/static/triggers.html

John,

Thanks for the comment. We try to stick as close as possible to the SQL standard. However, implementation of something event driven like triggers depends on what the back-end is capable of and how much efforts it need to get it working. I think there are currently no preparations as such in the back-end to support these structures.

John Wheeler wrote:

You might want to take at the triggers of DB2. Very thorough implementation. DB2 even has instead of triggers on Views.

http://publib.boulder.ibm.com/infocenter/db2help/topic/com.ibm.db2.udb.doc/a...

Just my 2 cents.

John Wheeler

On 7/14/05, Fabian Fabian.Groffen@cwi.nl wrote:

...

Currently there are no triggers in MonetDB/SQL.

Niels knows if and when they will appear. What is it exactly that you want to achieve? "ON DELETE CASCADE" constructs, or more complicated "ON UPDATE EXECUTE compute_aggr()" like things?

Regards, Fabian

Arthur van Bunningen wrote:

...

Dear all,

First my compliments with this piece of useful and implemented research. Second I was wondering if there is a possibility to have so-called "triggers" in MonetDB such as in for example PostgreSQL [1] or if there are other ways to use MonetDB as an "active database".

If anyone has experiences in this field or can point me to the right place to look for this experience I would be very thankful.

Kind regards,

Arthur van Bunningen

[1] http://www.postgresql.org/docs/8.0/static/triggers.html

---

SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users