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
3915	manage.py loaddata doesn't update table sequence numbers under Postgres	Russell Keith-Magee	Russell Keith-Magee	"If you are using Postgres and you dump the contents of a database, then load it again using loaddata, the sequence numbers for the dumped table are reset. For some reason, saving the objects as a result of the loaddata doesn't appear to update the sequence numbers. 

This manifests as the following error:
{{{
ERROR: duplicate key violates unique constraint ""myproj_myapp_pkey""
INSERT INTO ""myproj_myapp""
}}}

being raised when you add the first new object after loading the database contents.
"		closed	Core (Serialization)	dev		duplicate			Accepted	0	0	0	0	0	0