Re: [GENERAL] postgres cascade weird behaviour

2009-04-17 Thread Adrian Klaver
On Thursday 16 April 2009 6:50:46 pm Irwan Hendra wrote: > Hi > > I have table A with pk that is being referenced by 5 other tables as > foreign key > I have put all those tables reference to be ON DELETE CASCADE > However for some reason when I tried to delete one of the row in table A, > out of 5

[GENERAL] postgres cascade weird behaviour

2009-04-16 Thread Irwan Hendra
Hi I have table A with pk that is being referenced by 5 other tables as foreign key I have put all those tables reference to be ON DELETE CASCADE However for some reason when I tried to delete one of the row in table A, out of 5 tables, 1 of them didn't actually get deleted but the transaction is