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
11156	Unnecessary savepoints with Oracle	Richard Davies <richard.davies@…>		"Savepoints are implemented in the Postgresql and Oracle backends, and provide a useful features to users of both.

In addition, the framework itself wraps various calls in savepoints (e.g. inside django/db/models/query.py:get_or_create). This is to work around a Postgresql-specific oddity that the open transaction needs to be rolled back to a prior savepoint if it experiences a database exception.

This oddity is not present on Oracle, so the extra savepoints are not required. We probably need to split the current single backend flag uses_savepoints into two: can_savepoint and needs_savepoint_after_exception.

See http://groups.google.com/group/django-developers/browse_thread/thread/bca33ecf27ff5d63"	Cleanup/optimization	closed	Database layer (models, ORM)	dev	Normal	wontfix	oracle savepoints	richard.davies@… Matt Boersma Erin Kelly	Accepted	1	0	1	0	0	0