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
27708	Relation between tables in different schemas with big names	felipeps	nobody	"I'm using Django 1.9.7 with Postgresql.

When I try to migrate  a relation between two tables in different schemas, for example: a table named ''**product**'', which is in a schema named ''**dataflex**'' and another table named ''**client_product_sale_stc**'' in another schema.

I got this error:

----

django.db.utils.ProgrammingError: ERRO:  syntax error at or near ""dataflex""
LINE 1: ...CONSTRAINT ""client_product_setor_id_52aad07a_fk_""dataflex""....

----

After sometime trying to figure It out a solution for this problem, I tried to change the schemas's name to just ''**df**'' instead of ''**dataflex**'' and It worked perfectly.

I also tried to decreased table's name size and It worked just like when I decreased schema's name size, so It seems to be a problem with big constraints names.

I'm using the following syntax:

db_table = '""dataflex"".""product""'

**setor_id** is the name of the field of the relation in client_product_sale_stx model/table. 
product model/table does not have a field for the relation.


**Examples models:**
{{{
class ClientProductSaleStc():
    local_id = models.ForeignKey(EstoqueLocal, db_column='local_id')
    empresa_id = models.ForeignKey(Sced015, db_column='empresa_id')
    subcategoria_id = models.ForeignKey(ProdutoSubcategoria, db_column='subcategoria_id')
    produto_id = models.ForeignKey(ProdutoProduto, db_column='produto_id')
    setor_id = models.ForeignKey(Product, db_column='setor_id')

    class Meta:
        db_table = 'client_product_sale_stc'


class Product():
    recnum = models.BigIntegerField(unique=True)
    hor_due = models.DecimalField(max_digits=2, decimal_places=0)
    min_due = models.DecimalField(max_digits=2, decimal_places=0)

    class Meta:
        db_table = '""dataflex"".""product""'
}}}


"	Bug	new	Migrations	1.9	Normal		different schema relation		Unreviewed	0	0	0	0	0	0