#3460: postgresql_psycopg2 backend uses wrong isolation level
-------------------------------------------------+--------------------------
Reporter: Jack Moffitt <[EMAIL PROTECTED]> | Owner: adrian
Status: new | Component:
Database wrapper
Version: SVN | Resolution:
Keywords: | Stage:
Unreviewed
Has_patch: 1 | Needs_docs: 0
Needs_tests: 0 | Needs_better_patch: 0
-------------------------------------------------+--------------------------
Changes (by Jack Moffitt <[EMAIL PROTECTED]>):
* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0
Comment:
Note that this patch may have side effects if the database's default
isolation level is set to serializable. The attached patch corrects this
problem and makes sure that we're always in read committed unless
otherwise overridden for the entire session. See
http://www.postgresql.org/docs/8.1/interactive/sql-set-transaction.html
for documentation.
I'm also attaching a test script to show that this works.
Note that the self._commit() call is uncessary in autocommit isolation
mode, but is needed for the others.
--
Ticket URL: <http://code.djangoproject.com/ticket/3460#comment:1>
Django Code <http://code.djangoproject.com/>
The web framework for perfectionists with deadlines
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en
-~----------~----~----~----~------~----~------~--~---
