#28141: When have null=True inside ForeignKey, Django don't to do CASCADE
Operation
even passing on_delete=models.CASCADE. [using PostgreSQL]
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
mateuspadua |
Type: | Status: new
Uncategorized |
Component: Database | Version: 1.10
layer (models, ORM) | Keywords: ForeignKey null
Severity: Normal | True PostgreSQL
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
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".
--
Ticket URL: <https://code.djangoproject.com/ticket/28141>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/054.64227d1e30d5dd3e43e2ce3076dc7fe9%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
