Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 84428 invoked from network); 9 Nov 2008 06:02:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 9 Nov 2008 06:02:09 -0000 Received: (qmail 29810 invoked by uid 500); 9 Nov 2008 06:02:15 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 29786 invoked by uid 500); 9 Nov 2008 06:02:14 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 29775 invoked by uid 99); 9 Nov 2008 06:02:14 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Nov 2008 22:02:14 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of amichail@gmail.com designates 74.125.44.29 as permitted sender) Received: from [74.125.44.29] (HELO yx-out-2324.google.com) (74.125.44.29) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 09 Nov 2008 06:00:53 +0000 Received: by yx-out-2324.google.com with SMTP id 3so741555yxj.85 for ; Sat, 08 Nov 2008 22:01:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:mime-version:content-type:content-transfer-encoding :content-disposition; bh=7qobdwrnlazU++Q4J6vadjykktn/CfvnnqvKuz/+U2w=; b=LAeC0Y4dnSXEN80wfccnPVkynXyj3PqN/ZjWcuVA8Zmgp+bXPlrVzXbbhTIh6DD+K1 Wq8H7rxkjtjyLIDunFiR6Qb4Bjt4d4hm7yH89qUy+LX4CUu3bqjw3kqnrNI0h8hMwlE2 anHK5uzRpWK2GlnJJ/RA6O0zgtwXbl32JBo6k= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type :content-transfer-encoding:content-disposition; b=vNDnqw6fmH/aTGzkOMkTgQnqmbfibZccWArBsj/O3+MMBcr+r2uMAt2DRuCvsSMURm wFyx4+w90pSJudFEu3hw5oYiXm2IBdEbFiup71pgCkxRxeoCbf4D/2FnYqlauCMNc8Qo fDXx0XrlQsgP/Ej2xK1MoQYAKDleW5e4JilHM= Received: by 10.100.142.4 with SMTP id p4mr1112113and.23.1226210490107; Sat, 08 Nov 2008 22:01:30 -0800 (PST) Received: by 10.100.38.9 with HTTP; Sat, 8 Nov 2008 22:01:30 -0800 (PST) Message-ID: Date: Sun, 9 Nov 2008 01:01:30 -0500 From: "Amir Michail" To: "Derby Discussion" Subject: How to delete with circular foreign key constraints? MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Checked: Checked by ClamAV on apache.org Hi, Is there an easy way to delete data in the presence of circular foreign key constraints? That is, how do you delete items from two or more tables at once so that these constraints are not violated? Amir -- http://chatbotgame.com http://numbrosia.com http://twitter.com/amichail