Opened 8 years ago
Last modified 8 years ago
#28141 closed Uncategorized
When have null=True inside ForeignKey, Django don't to do CASCADE Operation even passing on_delete=models.CASCADE. [using PostgreSQL] — at Initial Version
Reported by: | mateuspadua | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 1.10 |
Severity: | Normal | Keywords: | ForeignKey null True PostgreSQL |
Cc: | mateuspaduaweb@… | Triage Stage: | Unreviewed |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
Example:
from cms.models import Page
class OfferingPlugin(CMSPlugin):
image = VersatileImageField(upload_to=unique_upload, ppoi_field='ppoi')
ppoi = PPOIField()
title = models.CharField(max_length=50)
subtitle = models.CharField(max_length=140)
link_copy = models.CharField(max_length=20)
link_address = models.ForeignKey(Page, blank=True, null=True, on_delete=models.CASCADE) -> dont work because has null=True
....
page = Page.objecs.first()
If I to try delete a Page instance, for example page.delete() the error bellow will occur:
.....
IntegrityError: insert or update on table "offering_offeringplugin" violates foreign key constraint "offering_offering_cmsplugin_ptr_id_9a9e9998_fk_cms_cmsplugin_id"
DETAIL: Key (id)=(10) is still referenced from table "offering_offeringplugin".