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

Sander Kruseman kruseman at xs4all.nl
Tue Oct 30 21:43:13 CET 2007


Hi Romulo,

Thanks for your response. I downloaded the latest Windows installer 
today, and installed on XP.

# MonetDB server v5.2.0, based on kernel v1.20.0
...
# MonetDB/SQL module v2.20.0 loaded

Good to hear that apparently this has been fixed in the CVS trunk.

Regards,
Sander

Romulo Goncalves wrote:
> 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
> 
> 
> -------------------------------------------------------------------------
> 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