Michael Bayer wrote: >> From time to time I get this error when processing my own query in >> from_statement: >> >> ProgrammingError: (ProgrammingError) current transaction is aborted, >> commands ignored until end of transaction block
> a previous statement failed within the transaction and must be rolled back > before proceeding. This is a postgres requirement. This is just FYI: I think I worked out what is causing this: 1. when I edit the program file that is importing session and other objects from file with SQLA definitions (table defs, mappers etc), it is automatically reloaded (by mod_python) 2. then, when from_statement() query happens to be executed, something goes haywire within session. When reqular ORM commands (filter() etc) are executed after my program reload, this does not happen, only when using from_statement() and literal SQL. Regards, mk --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
