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
1208	db_table with schema name does not work on PostgreSQL	slamb@…	Adrian Holovaty	"If I give Django a db_table of ""loadtest.machine"", it passes to PostgreSQL ""loadtest.machine"", in quotes. PostgreSQL wants ""loadtest"".""machine"". There needs to be some way of passing in a schema-qualified table name, such as:

 * pass in the latter, at the expense of not supporting an actual '.' in the name).
 * support a db_schema attribute, maybe, so there's no ambiguity.

My code used to work, but Django added some quoting.

Here's an example of the errors pgsql gives:

{{{
loadtest=# select count(*) from ""loadtest"".""experiment"";
 count 
-------
    25
(1 row)

loadtest=# select count(*) from ""loadtest.experiment"";
ERROR:  relation ""loadtest.experiment"" does not exist
}}}"	defect	closed	Database layer (models, ORM)		normal	duplicate			Unreviewed	0	0	0	0	0	0