Re: [BUGS] Foreign key constaint can be broken

2010-01-26 Thread Fabien COELHO
I found a way to break a foreign key constraint in PostgreSQL [ ie, make a rule that defeats an ON DELETE CASCADE operation ] This isn't a bug, it's just the way things work. Rules (and triggers) apply to the commands that implement foreign key updates, so a poorly written rule can make those

Re: [BUGS] Foreign key constaint can be broken

2010-01-26 Thread Tom Lane
Mark Kazemier writes: > I found a way to break a foreign key constraint in PostgreSQL > [ ie, make a rule that defeats an ON DELETE CASCADE operation ] This isn't a bug, it's just the way things work. Rules (and triggers) apply to the commands that implement foreign key updates, so a poorly writ