Opened 17 years ago

Closed 17 years ago

Last modified 8 years ago

#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)

comment:1 by Malcolm Tredinnick, 17 years ago

Resolution: → invalid
Status: new → closed

SQLite does not support foreign keys at all.

in reply to:  1 comment:2 by potpath, 8 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 Tim Graham, 8 years ago

#14204 is the ticket for adding support for foreign key constraints on SQLite.

Note: See TracTickets for help on using tickets.
Back to Top