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
5710	dumpdata/loaddata fails with many-to-many tables on postgresql	davep@…	nobody	"I did a (manage.py) dumpdata then loaddata with some models that had many to many fields. The subsequent loaddata operation failed with an error: 
{{{
psycopg2.ProgrammingError: relation ""keywordsites_site__site__keywords"" does not exist.
}}}
The problem is that the name of the table is reduced to lower case where the name of the table is actually has an uppercase S
{{{
keywordsites_site__Site__keywords
}}}
and further investigation revealed that the generated SQL had the correct capitalisation but the table name was not quoted - hence the problem.

The fix is to change line 96 on django/db/backends/postgresql/operations.py to:
{{{
                output.append(""%s setval('%s', coalesce(max(%s), 1), max(%s) %s null) %s \""%s\"";"" % \
}}}

No idea how to make a .diff, sorry, but for a single line I'm sure you can cope. It would be nice to be able to turn WikiFormatting off inline too."		closed	Database layer (models, ORM)	dev		fixed	manage.py loaddata dumpdata postgresql	gary.wilson@… real.human@… arthur.case@… tom@… mark@… portland@… floguy@… django@… remco@… eliott@… pythonmailing@…	Ready for checkin	1	0	0	0