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.
What does the db_table in your model definition look like? It should just be:
db_table = 'foo' # Django will take foo and change it to "FOO", which is how Oracle interprets foo
not:
db_table = '"foo"' # Since this is already quoted, I think Django won't change it, and then Oracle won't be able to find the table because it is explicitly the wrong case.
Cheers,
Ian
You received this message because you are subscribed to the Google Groups "Django users" group.
To view this discussion on the web visit https://groups.google.com/d/msg/django-users/-/GJh1mmeq6KMJ.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
No comments:
Post a Comment