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

2009-07-02 Thread Michaël Lemaire
x27; triggers. I really need the order to be C then B then A. Is there a reason for the triggers to fire in this order ? Has anyone an idea to reverse it ? Thanks in advance. Michaël Lemaire -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscri

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

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 a