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
53	djonga-admin.py sqlclear fails with entries in auth_permissions tables	Dobbes	Adrian Holovaty	"Running the sql output from djonga-admin.py sqlclear blog

BEGIN;
DELETE from content_types WHERE package = 'blog';
DELETE FROM packages WHERE label = 'blog';
DROP TABLE blog_entries;
COMMIT;

Returns the following error:

ERROR:  update or delete on ""packages"" violates foreign key constraint ""auth_permissions_package_fkey"" on ""auth_permissions""
DETAIL:  Key (label)=(blog) is still referenced from table ""auth_permissions"".

This is pretty much what it says that there are still fields in the auth_permissions table that reference the blog package, so it can't be deleted. I created the simple patch for it and will attach.


"	defect	closed	Tools		normal	fixed			Ready for checkin	0	0	0	0	0	0