id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
19931	Deleting from Site model won't cascade delete related models	james_lin	nobody	"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"	Bug	closed	contrib.sites	1.4	Normal	needsinfo	cascade, delete, sites		Unreviewed	0	0	0	0	0	0