Skip to content
This repository has been archived by the owner on Nov 1, 2020. It is now read-only.

table with schema reference #2

Closed
omargiorgetti opened this issue Jan 19, 2015 · 2 comments
Closed

table with schema reference #2

omargiorgetti opened this issue Jan 19, 2015 · 2 comments

Comments

@omargiorgetti
Copy link

Hi, I'm using pymssql from a django framework on centos7 on viirtualbox to Ms SqlServer 2008 R2 Express. I'm using the meta instrtuction like db_table=schema].[table.
When django generate the sql create a "create index" statement with name the schema and table separated with point. That's the generated error "django.db.utils.ProgrammingError: (102, "Incorrect syntax near '.'.DB-Lib error message 20018,".

@manfre
Copy link
Contributor

manfre commented Jan 19, 2015

This may or may not be a pymssql specific error, but relying upon "schema].[table" is not recommended or officially supported by django-mssql.

@aaugustin
Copy link
Owner

Yes, that's a hack and I have little interest in researching a way to support it. If you have a patch I'll look into it. However I suspect it will be a patch for pymssql or django-mssql. django-pymssql is a very small bridge; these libraries do all the heavy lifting.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants