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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users