I'm doing a simple query like this, to get a list of dealers with open invoices:
session.query(Invoice.dealer_id, Dealer.name).
outerjoin((Dealer, Invoice.dealer)).
group_by(Invoice.dealer_id, Dealer.name).
all()
Which produces this SQL:
SELECT invoices.dealer_id AS
On 11/5/2010 2:50 PM, Michael Hipp wrote:
That SQL runs perfectly when given directly to PostgreSQL, but SQLAlchemy is
reporting a DB-API error:
sqlalchemy.exc.InternalError: (InternalError) current transaction is
aborted, commands ignored until end of transaction block
Nevermind. I noticed
Hey,
I'm applying finishing touches to my web app before rolling it out,
when this strange error occurs:
sqlalchemy.exc.InternalError
InternalError: (InternalError) current transaction is aborted,
commands ignored until end of transaction block 'SELECT count(1) AS
count_1 \nFROM personal_message
On Sep 29, 2010, at 7:13 AM, tom wrote:
Hey,
I'm applying finishing touches to my web app before rolling it out,
when this strange error occurs:
sqlalchemy.exc.InternalError
InternalError: (InternalError) current transaction is aborted,
commands ignored until end of transaction block