Deleting from Site model won't cascade delete related models

[james_lin]

I have asked this in Stackoverflow and received no valid response, so I think I might raise the issue here.

I have a django project currently hosting multiple sites, and now I need to split them into different projects with different databases.

So I cloned the project and thinking delete the records in Site model will cascade delete all data related to the sites I am deleting and leaving the ones that relates to the site record I am keeping.

I have the following code in management command to delete the sites:

Site.objects.filter(~Q(domain=options.get("domain"))).delete()

But I am getting error like this:

django.db.utils.IntegrityError: update or delete on table "django_site" violates foreign key constraint "core_staticpage_site_id_fkey" on table "core_staticpage"
DETAIL:  Key (id)=(4) is still referenced from table "core_staticpage".

More info:
This error applies to ForeignKey and ManyToManyField
Django version is 1.4.3
No on_delete overwrite were found in project

[Jacob]

There isn't anything that Site does differently from any other model, so I don't think this is a bug in Django. I'm guessing this has to do with whatever this "core_staticpage" table/model is, but without seeing that I can't be sure.

If you can provide a minimal test case that reproduces the problem without this external dependency please feel free to reopen the ticket, but for now I'm going to close it as I'm fairly sure this doesn't represent a bug with Django.