#16047: postgresql_psycopg2 never restores autocommit mode when leaving
transaction
management
-------------------------------------+-------------------------------------
Reporter: brodie | Owner: nobody
Type: Bug | Status: new
Milestone: | Component: Database layer
Version: 1.3 | (models, ORM)
Resolution: | Severity: Normal
Triage Stage: | Keywords: psycopg2 autocommit
Unreviewed | transactions
Needs documentation: 0 | Has patch: 1
Patch needs improvement: 0 | Needs tests: 0
| Easy pickings: 0
-------------------------------------+-------------------------------------
Changes (by brodie):
* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0
Comment:
Also, I should mention that I've run the test suite with my patches
applied against the releases/1.3.X branch. All tests pass with DB-level
autocommit disabled and enabled. I'm using psycopg2 2.4.1 and PostgreSQL
9.0.4. I haven't tested other combinations of psycopg2, PostgreSQL, or
other DBs.
Here are the two test settings files I used:
{{{
#!python
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'djangotest',
'USER': 'djangotest',
'PASSWORD': 'djangotest',
},
'other': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'djangotestother',
'USER': 'djangotestother',
'PASSWORD': 'djangotestother',
}
}
}}}
{{{
#!python
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'djangotest',
'USER': 'djangotest',
'PASSWORD': 'djangotest',
'OPTIONS': {'autocommit': True},
},
'other': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'djangotestother',
'USER': 'djangotestother',
'PASSWORD': 'djangotestother',
'OPTIONS': {'autocommit': True},
}
}
}}}
--
Ticket URL: <http://code.djangoproject.com/ticket/16047#comment:1>
Django <https://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 django-updates@googlegroups.com.
To unsubscribe from this group, send email to
django-updates+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-updates?hl=en.
