diff options
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 ------------------ |