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