How to use django models with foreign keys in different DBs?

by

Cross-database limitations

Django doesn’t currently provide any support for foreign key or many-to-many relationships spanning multiple databases. If you have used a router to partition models to different databases, any foreign key and many-to-many relationships defined by those models must be internal to a single database.

Django – limitations-of-multiple-databases

Trouble

Same trouble. Bug in ForeignKey() class.

In validate() method.

See ticket

Bug exists in v1.2, v1.3, v1.4rc1

Solution

Try this patch to solve it.

More Related Contents:

  1. How can I temporarily disable a foreign key constraint in MySQL?
  2. Problems with contenttypes when loading a fixture in Django
  3. MySQL Error 1215: Cannot add foreign key constraint
  4. Mysql error 1452 – Cannot add or update a child row: a foreign key constraint fails
  5. MySQL foreign key constraints, cascade delete
  6. How do I see all foreign keys to a table or column?
  7. MySQL Cannot Add Foreign Key Constraint
  8. Required to join 2 tables with their FKs in a 3rd table
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. Basics of Foreign Keys in MySQL?
  11. How do I use on delete cascade in mysql?
  12. Add Foreign Key to existing table
  13. How to change the foreign key referential action? (behavior)
  14. How to create relationships in MySQL
  15. How to truncate a foreign key constrained table?
  16. MySQL InnoDB foreign key between different databases
  17. MySQL Removing Some Foreign keys
  18. Force InnoDB to recheck foreign keys on a table/tables?
  19. Show constraints on tables command
  20. Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3
  21. Django MySQL full text search
  22. MySQL foreign key to allow NULL?
  23. MySQL Errno 150
  24. GROUP_CONCAT equivalent in Django
  25. What’s the best way to migrate a Django DB from SQLite to MySQL?
  26. Foreign key constraints: When to use ON UPDATE and ON DELETE
  27. MySQL DROP all tables, ignoring foreign keys
  28. MySQL “ERROR 1005 (HY000): Can’t create table ‘foo.#sql-12c_4’ (errno: 150)”
  29. MySQL errorno 121
  30. MySQL Relationships

Leave a Comment