Hi Gijs No. Foreign key constraints are there for a good reason and disabling them creates a, albeit temporarily, inconsistent database state. It is the client side, i.e. DBA, that has to decide on this. For this he can take a mserver offline for maintenance (using monetdb) and perform the necessary actions. There no TRUNCATE multiple tables command. regards, Martin On 6/7/13 2:21 PM, Gijs Molenaar wrote:
Hi monetdb people,
I'm doing some work again on Djonet, implementing missing features. One of the features is to flush the content of a set tables e.g. remove all rows. The problem is that the order the tables are processed is important in the case of foreign key relations.
They way this is implemented in other database drivers for django is to temporarily disable foreign key relations (mysql) or to TRUNCATE multiple tables in one statement (postgresql). Is there an (undocumented) way of accomplishing something similar? I prefer not to temporarily alter the table.
Thanks,
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list