#psycopg

How to: DatabaseError: current transaction is aborted, commands ignored until end of transaction block

DatabaseError: current transaction is aborted, commands ignored until end of transaction block

I got a lot of errors with the message :

"DatabaseError: current transaction is aborted, commands ignored until end of transaction block"

after changed from python-psycopg to python-psycopg2 as Django project’s database engine.

The code remains the same, just dont know where those errors are from.

Answ…

One project I work on involves using Django connected to a backend PostgreSQL database.  The glue between these two (specifically Python and PostgreSQL) is made up of the python Psycopg2 package.  

It turns out that there is a clash between the latest versions of Django (1.3) and Psycopg2 (2.4.2).  Here is the bug report with the Django devs.  The solution is "Don't use psycopg2 2.4.2, just use 2.4.1".  Simple enough.

It would be nice to work with everything in the standard Ubuntu repositories, but especially for dev packages, these often are either extremely out of date, or extremely up to date, but with no option of installing older versions.  However this was not that big of a deal to fix.  Simply uninstall Ubuntu's psycopg2 package, then install the PyPI installer: 

sudo apt-get install python-pip

Then install the specific pyscopg2 version with PyPI:

sudo pip install psycopg2==2.4.1

Para começar a usar Django com banco PostgreSQL, precisei instalar o Psycopg para permitir que o meu interpretador Python converse com o meu banco PostgreSQL, em um OS X.

Detalhes:

PostgreSQL 9.0

Python 2.6.6

Psycopg 2.4.2

Django 1.3

Mac OS X Snow Leopard

Depois de instalar Python, PostgreSQL e Django, baixei o arquivo do Psycopg. Unzipei. Quando tento instalar seguindo o tutorial do Psycopg, ele dá pau, mandando uma msg dizendo que um tal de pg_config não está no PATH. Para tanto, basta entrar no terminal e digitar o seguinte comando:

export PATH=$PATH:/Library/PostgreSQL/9.0/bin

Aí é só entrar na pasta do psycopg pelo terminal e rodar a instalação:

sudo python setup.py install

Obs: Eu usei sudo devido ao "Permission denied" da pasta /opt/local/:

error: could not create '/opt/local/Library/Frameworks/Python.framework/Versions/2.6/lib/python2.6/site-packages/psycopg2': Permission denied

Créditos:

http://stackoverflow.com/questions/846383/problem-installing-pyscopg2-on-mac-os-x