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

Sander Kruseman kruseman at xs4all.nl
Tue Oct 30 21:23:58 CET 2007


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




More information about the users-list mailing list