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
3740	Django creates wrong query for postgresql 8.1	me@…	Adrian Holovaty	"I'm getting a programming error 'missing FROM-clause entry for table ""mail_domain""'. The query that django constructed was:

'SELECT ""mail_alias"".""id"",""mail_alias"".""address"",""mail_alias"".""domain_id"",""mail_alias"".""enabled"" FROM ""mail_alias"" ORDER BY ""mail_domain"".""name"" ASC'

which works when I add mail_domain to the from-clause as

'SELECT ""mail_alias"".""id"",""mail_alias"".""address"",""mail_alias"".""domain_id"",""mail_alias"".""enabled"" FROM ""mail_alias"", ""mail_domain"" ORDER BY ""mail_domain"".""name"" ASC'

The model for Alias which triggers the bug is attached. I'm using the current (r4739) trunk.
"		closed	Database layer (models, ORM)	dev		duplicate			Unreviewed	0	0	0	0	0	0