4.6.2012 14:36, rahajiyev kirjoitti:
Why is Django strangely quoting column and table names? It gives
Oracle syntax errors.
DatabaseError at /
relation "foo" does not exist
LINE 1: ...ty", "foo"."address_country" FROM "foo"."...
Of course it exists as foo, not as "foo".
I already did the CREATE SYNONYM trick to avoid messing with schemas.
By default Oracle makes following assumption: if given name (column,
table, schema etc.) is not quoted it's converted implicitly to uppercase
and used as that.
Thus clause: select * from SoMeTaBle becomes to select * from "SOMETABLE".
If you provide quotes Oracle uses table name as is and thus making it
case-sensitive.
In theory Django should make all names uppercase regradless how you
write it. I recall someone to complain strange behavior in cases with
Oracle backend.
--
Jani Tiainen
- Well planned is half done and a half done has been sufficient before...
--
You received this message because you are subscribed to the Google Groups "Django
users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.