#5698 closed Uncategorized (invalid)
sqlite backend missing foreign keys
Reported by: | davisp | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | dev |
Severity: | Normal | Keywords: | sqlite foreign key |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
The sqlite backend is missing some foreign key constraints. Specifically, auth_permissin.content_type_id never gets marked as a foreign key.
Change History (3)
follow-up: 2 comment:1 by , 17 years ago
Resolution: | → invalid |
---|---|
Status: | new → closed |
comment:2 by , 9 years ago
Easy pickings: | unset |
---|---|
Severity: | → Normal |
Type: | → Uncategorized |
UI/UX: | unset |
Replying to mtredinnick:
SQLite does not support foreign keys at all.
Update:
SQLite support foreign key since version 3.6.19.
There are some workarounds here:
https://stackoverflow.com/questions/6745763/enable-integrity-checking-with-sqlite-in-django
comment:3 by , 9 years ago
#14204 is the ticket for adding support for foreign key constraints on SQLite.
Note:
See TracTickets
for help on using tickets.
SQLite does not support foreign keys at all.