summaryrefslogtreecommitdiff
path: root/lib/sqlalchemy/dialects/postgresql/base.py
diff options
context:
space:
mode:
authorMike Bayer <mike_mp@zzzcomputing.com>2016-03-15 17:11:08 -0400
committerMike Bayer <mike_mp@zzzcomputing.com>2016-03-15 17:17:21 -0400
commit31f96c27a5fea302358ba580313a2f742c12b83d (patch)
tree5ba8ebb50ead2ef07c9bf9b5ec1871ce1564aba8 /lib/sqlalchemy/dialects/postgresql/base.py
parent224b03f9c006b12e3bbae9190ca9d0132e843208 (diff)
downloadsqlalchemy-31f96c27a5fea302358ba580313a2f742c12b83d.tar.gz
- changelog and docs for #3332, fixes #3332
- make docs for isolation level more consistent between postgresql and mysql - move mysql autocommit tests
Diffstat (limited to 'lib/sqlalchemy/dialects/postgresql/base.py')
-rw-r--r--lib/sqlalchemy/dialects/postgresql/base.py10
1 files changed, 4 insertions, 6 deletions
diff --git a/lib/sqlalchemy/dialects/postgresql/base.py b/lib/sqlalchemy/dialects/postgresql/base.py
index b16a82e04..c0a3708d4 100644
--- a/lib/sqlalchemy/dialects/postgresql/base.py
+++ b/lib/sqlalchemy/dialects/postgresql/base.py
@@ -50,11 +50,12 @@ Transaction Isolation Level
All Postgresql dialects support setting of transaction isolation level
both via a dialect-specific parameter :paramref:`.create_engine.isolation_level`
accepted by :func:`.create_engine`,
-as well as the ``isolation_level`` argument as passed to
+as well as the :paramref:`.Connection.execution_options.isolation_level` argument as passed to
:meth:`.Connection.execution_options`. When using a non-psycopg2 dialect,
this feature works by issuing the command
``SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL <level>`` for
-each new connection.
+each new connection. For the special AUTOCOMMIT isolation level, DBAPI-specific
+techniques are used.
To set isolation level using :func:`.create_engine`::
@@ -76,10 +77,7 @@ Valid values for ``isolation_level`` include:
* ``READ UNCOMMITTED``
* ``REPEATABLE READ``
* ``SERIALIZABLE``
-
-The :mod:`~sqlalchemy.dialects.postgresql.psycopg2` and
-:mod:`~sqlalchemy.dialects.postgresql.pg8000` dialects also offer the
-special level ``AUTOCOMMIT``.
+* ``AUTOCOMMIT`` - on psycopg2 / pg8000 only
.. seealso::