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
8659	Quote relation name creating PostgreSQL database	Hystrix	nobody	"Using PostgreSQL as a database backend, if I define a model with a foreignkey field with an uppercase letter in the attribute name, the relation constrait name would end with all the letters in lowercase. This can have various side effects such as not being able to reset the database becuase Django can't remove the constrait (it tries to remove a constrait with uppercase letters and the one in the database is all lowercase).
This happens because the constraint name is not quoted when the database is created.
All it takes to fix this is add backend.quote_name to the name while creating the sql.
I fixed it in 0.96 but I can't find where this should be changed in SVN.

Bad SQL:
{{{ALTER TABLE ""proto0_viaje"" ADD CONSTRAINT reservadoPor_id_refs_id_331c0818 FOREIGN KEY (""reservadoPor_id"") REFERENCES ""proto0_empleado"" (""id"") DEFERRABLE INITIALLY DEFERRED;}}}

Good SQL:
{{{ALTER TABLE ""proto0_viaje"" ADD CONSTRAINT ""reservadoPor_id_refs_id_331c0818"" FOREIGN KEY (""reservadoPor_id"") REFERENCES ""proto0_empleado"" (""id"") DEFERRABLE INITIALLY DEFERRED;}}}"		closed	Database layer (models, ORM)	dev		invalid			Accepted	0	0	0	0	0	0