I’ve set up a 1-M-M relationship between 3 tables/models. I can’t get
cascading deletes (haven’t tried updates yet) to work when the master
record is deleted. I’m using MySQL 4.1.x, and the error message is:
Mysql::Error: #23000Cannot delete or update a parent row: a foreign key
constraint fails: DELETE FROM contact_addresses WHERE (contact_id = 1).
Is this something that’s not supported by MySQL? Or might I have setup
my models (has_many, belongs_to, etc.) incorrectly?