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