id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 17875 ForeignKey field and Multiple database bug vital.fadeev@… nobody "Hello. == Problem: == I get error ""Incorrect table name"" when I save entry. == Details: == I have two models: {{{ # db1 class User(models.Model): id = models.PositiveIntegerField(primary_key=True) # db2 class Realtor(models.Model): realtor_id = ForeignKey(User) }}} where 'User' in using 'db1' and 'Realtor' using 'db2' (via router).[[BR]] I get error while save. [[BR]] When trace I see variables who using '''db2'''. [[BR]] And SQL-requests going to '''db2'''.[[BR]] [[BR]] I.e. SQL-requests runned on Realtor's database - 'db2'[[BR]] (in db2 no table 'User' and I get 'Incorrect table name' error)[[BR] [[BR]] == Solution: == (Please, say me right I or no)[[BR]] ForeignKey field in '''validate()''' function using database from field instance class. [[BR]] But need using from related class.[[BR]] {{{ using = router.db_for_read(model_instance.__class__, instance=model_instance) }}} [[BR]] (please, see attachment - patch) I see it in 1.2, 1.3, 1.4rc1. " Bug closed Uncategorized 1.6 Normal wontfix ForeignKey, multiple database Unreviewed 1 0 0 0 0 0