On Nov 7, 2009, at 6:48 PM, Jacek Kałucki wrote:
> I'm trying to create simple application setup wizard and I
> encountered a
> problem.
> My code is:
> conn = dabo.db.dConnection(self.connectInfo)
> cursor = conn.getDaboCursor()
> cursor.execute("select * from users")
>
> For SQLite backend everything works fine, but for PostgreSQL,
> execute raises an exception:
> File "c:\python25\lib\site-packages\dabo\db\dCursorMixin.py",
> line
> 332, in execute
> raise dException.DBQueryException(errMsg, sql)
> dabo.dException.DBQueryException: current transaction is aborted,
> commands ignored until end of transaction block
> SQL: select * from users
>
> Pure psycopg2 cursor also works correctly, but Dabo cursor don't.
> What I'm doing wrong?
Did you run any other queries before this that might have left things
in an aborted state? If not, it must have been one of the Dabo
cursor's internal queries. What version of PostgreSQL are you working
with?
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
