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,"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,,