Deleting from Site model won't cascade delete related models
|Reported by:||james_lin||Owned by:||nobody|
|Severity:||Normal||Keywords:||cascade, delete, sites|
|Has patch:||no||Needs documentation:||no|
|Needs tests:||no||Patch needs improvement:||no|
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:
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".
This error applies to ForeignKey and ManyToManyField
Django version is 1.4.3
No on_delete overwrite were found in project