Re: [GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-03 Thread Jasen Betts
On 2009-07-02, Michaël Lemaire wrote: > Richard Huxton wrote: > >> Michaël Lemaire wrote: >> > Hi all. >> > >> > I've come across a problem with delete cascade. >> > >> > I have three tables A, B and C. >> > Table B has a foreign key on A with delete cascade. >> > Table C has a foreign key on B

Re: [GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-02 Thread Michaël Lemaire
Richard Huxton wrote: > Michaël Lemaire wrote: > > Richard Huxton wrote: > >> Michaël Lemaire wrote: > >>> Hi all. > >>> > >>> I've come across a problem with delete cascade. > >>> > >>> I have three tables A, B and C. > >>> Table B has a foreign key on A with delete cascade. > >>> Table C has a

Re: [GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-02 Thread Richard Huxton
Michaël Lemaire wrote: Richard Huxton wrote: Michaël Lemaire wrote: Hi all. I've come across a problem with delete cascade. I have three tables A, B and C. Table B has a foreign key on A with delete cascade. Table C has a foreign key on B with delete cascade. So, we have this reference chai

Re: [GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-02 Thread Michaël Lemaire
Richard Huxton wrote: > Michaël Lemaire wrote: > > Hi all. > > > > I've come across a problem with delete cascade. > > > > I have three tables A, B and C. > > Table B has a foreign key on A with delete cascade. > > Table C has a foreign key on B with delete cascade. > > So, we have this referen

Re: [GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-02 Thread Richard Huxton
Michaël Lemaire wrote: Hi all. I've come across a problem with delete cascade. I have three tables A, B and C. Table B has a foreign key on A with delete cascade. Table C has a foreign key on B with delete cascade. So, we have this reference chain: C->B->A All three tables have an 'on delete' t

[GENERAL] Delete triggers order in delete cascade (pg 8.3.7).

2009-07-02 Thread Michaël Lemaire
Hi all. I've come across a problem with delete cascade. I have three tables A, B and C. Table B has a foreign key on A with delete cascade. Table C has a foreign key on B with delete cascade. So, we have this reference chain: C->B->A All three tables have an 'on delete' trigger. My problem is, w