diff options
| author | Ian Kelly <ian.g.kelly@gmail.com> | 2010-12-01 23:36:56 +0000 |
|---|---|---|
| committer | Ian Kelly <ian.g.kelly@gmail.com> | 2010-12-01 23:36:56 +0000 |
| commit | 1f68dc4ad4ddc67831c6aa047683a5b53fa33a37 (patch) | |
| tree | a5466d2d0fa6c9b5af078fc8da2fc5ab8c36b951 /docs/ref | |
| parent | dceaa82dec9f97ac77754dfdc737852d8171c8a2 (diff) | |
Fixed #11706: Added an Oracle connection option to disable the use of RETURNING INTO in INSERT statements.
git-svn-id: http://code.djangoproject.com/svn/django/trunk@14765 bcc190cf-cafb-0310-a4f2-bffc1f526a37
Diffstat (limited to 'docs/ref')
| -rw-r--r-- | docs/ref/databases.txt | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index 3aa78ef647..1406b7447e 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -585,6 +585,23 @@ your Oracle database configuration to True:: Failure to do this may result in crashes and other odd behavior. +INSERT ... RETURNING INTO +------------------------- + +By default, the Oracle backend uses a ``RETURNING INTO`` clause to efficiently +retrieve the value of an ``AutoField`` when inserting new rows. This behavior +may result in a ``DatabaseError`` in certain unusual setups, such as when +inserting into a remote table, or into a view with an ``INSTEAD OF`` trigger. +The ``RETURNING INTO`` clause can be disabled by setting the +``use_returning_into`` option of the database configuration to False:: + + 'OPTIONS': { + 'use_returning_into': False, + }, + +In this case, the Oracle backend will use a separate ``SELECT`` query to +retrieve AutoField values. + Tablespace options ------------------ |
