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

Fabian Groffen Fabian.Groffen at cwi.nl
Tue Oct 30 21:28:29 CET 2007


Hi Sander,

Please don't hijack threads.

Thanks.


On 30-10-2007 21:23:58 +0100, 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.
> 
> 
> 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