I’m trying to do like a ‘loaddata’ of json file which includes tables generated by Django-Simple-History, but I’m running into an obstacle because its possible for a HistoricalQuestion to refer to a Poll that has been deleted. The Poll lives on in the HistoricalPoll table, but the ForeignKey has to point to a non-deleted Poll.
This is data exported from a working database that is refusing to be reloaded due to a foreignKey constraint.
I need to be able to really delete things sometimes, and I’ve got existing data with this issue, so although a logical solution like only ever ‘inactivating’ instead of ever deleting would have avoided this, its too late.
Is there a way I can force this? I could, perhaps create the deleted projects as live objects and then delete them. Is there anything cleaner?