Return-Path: Delivered-To: apmail-incubator-cayenne-user-archive@locus.apache.org Received: (qmail 99894 invoked from network); 11 Oct 2006 01:11:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 11 Oct 2006 01:11:38 -0000 Received: (qmail 37783 invoked by uid 500); 11 Oct 2006 01:11:37 -0000 Delivered-To: apmail-incubator-cayenne-user-archive@incubator.apache.org Received: (qmail 37770 invoked by uid 500); 11 Oct 2006 01:11:37 -0000 Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cayenne-user@incubator.apache.org Delivered-To: mailing list cayenne-user@incubator.apache.org Received: (qmail 37760 invoked by uid 99); 11 Oct 2006 01:11:37 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Oct 2006 18:11:36 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [64.124.179.102] (HELO polatsk.objectstyle.org) (64.124.179.102) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 10 Oct 2006 18:11:34 -0700 Received: (qmail 2541 invoked from network); 11 Oct 2006 01:11:13 -0000 Received: from unknown (HELO ?::?????IPv6:::1?) (127.0.0.1) by localhost with SMTP; 11 Oct 2006 01:11:13 -0000 Mime-Version: 1.0 (Apple Message framework v752.3) In-Reply-To: <452A5213.2060707@najdi.si> References: <446E732D.5040901@pfrog.com> <71E3857E-CC22-456C-9813-DEE96ACC8A6E@gmail.com> <9813CBF2-1A71-4BDF-BC95-C3504631022D@objectstyle.org> <452A5213.2060707@najdi.si> Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable From: Andrus Adamchik Subject: Re: Parent/Child Insert ordering (was: Caching problem?) Date: Tue, 10 Oct 2006 21:11:12 -0400 To: cayenne-user@incubator.apache.org X-Mailer: Apple Mail (2.752.3) X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Oct 9, 2006, at 9:43 AM, Borut Bol=C4=8Dina wrote: > If db row "points" to the same db row then it would be cyclic (for =20 > example - someone is his/her own manager), otherwise just =20 > reflexive. Is this correct? Ok, it is coming back to me... "multi-reflexive" simply means that =20 there are multiple different relationships between the rows of the =20 same table. So I wouldn't worry about single row pointing to self, as =20= it doesn't violate constraints on insert, but say you have R1 and R2 =20 relationships within the same table (e.g. Category table; =20 parentCategory and relatedCategory relationships). There is a chance =20 that two or more rows will form a cycle: A -(parentCategory)-> B -=20 (relatedCategory)-> A. Andrus