[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 
> CASCADE);
> 
> INSERT INTO parent VALUES (1);
> INSERT INTO child 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?

Regards,
Romulo
> 
> 
> 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