When I try to delete a grandfather in a grandfather, father & son relationship as in the following, the grandfather and all the associated fathers are deleted, but the sons are left as orphans. It seems ROR can do a 2-tier cascading delete, but fails on a 3-tier cascading delete.
create_table "galleries", :force => true do |t| t.string "name" end
create_table "gallery_images", :force => true do |t| t.integer "gallery_id" end
create_table "gallery_image_profiles", :force => true do |t| t.integer "gallery_image_id" t.integer "profile_id" end
model gallery.rb class Gallery < ActiveRecord::Base has_many :gallery_images, :dependent =>:delete_all end
model gallery_image.rb class GalleryImage < ActiveRecord::Base belongs_to :gallery
has_many :gallery_image_profiles, :dependent => :delete_all end
model gallery_image_profile.rb class GalleryImageProfile < ActiveRecord::Base belongs_to :gallery_image belongs_to :profile end
controller: galleries_controller.rb class GalleriesController < ApplicationController def destroy @gallery = Gallery.find(params[:id]) @gallery.destroy redirect_to :action => 'list' end end