[MonetDB-users] 'on delete cascade' constraint over mapi fails

Romulo Goncalves R.A.Goncalves at cwi.nl
Tue Oct 30 21:30:54 CET 2007

Sander Kruseman wrote:
> Consider the following setup:
> CREATE TABLE parent (key int PRIMARY KEY);
> CREATE TABLE child (parent_key int REFERENCES parent (key) ON DELETE 
> INSERT INTO parent VALUES (1);
> Issuing from the JDBC terminal: DELETE FROM parent WHERE key = 1;
> properly results in deletion of both records.
> However, when issued over mapi, either from my custom C++ code or from 
> the provided Monet SQL client console, the same statement only deletes 
> the row from 'parent', ignoring the cascading constraint.
I just used my mclient to execute the queries on my MonetDB5 (5.21 
current cvs branch) with the SQL module loaded and it works.

Which version are you using and platform?

> Kind regards,
> Sander Kruseman
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> MonetDB-users mailing list
> MonetDB-users at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-users

More information about the users-list mailing list