On Sun, 13 Jun 2010 11:20:58 -0400, Michael Bayer <[email protected]>
wrote:
> When an exception occurs in a transaction while Postgresql, you in
> most cases must issue a rollback() (that is what "(InternalError)
> current transaction is aborted, commands ignored until end of
> transaction block" means, thats a PG message). Therefore you cannot
> attempt an operation with PG inside a transaction, have it fail,
> ignore the failure, then continue in the same transaction. You need
> to roll the transaction back and start a new one, or use an
> autocommit mode which accomplishes the same thing.
>> As far as 2, I'm not sure what "transactionalized execution" is.
> It means a statement is executed while a transaction is in progress.
> Each= subsequent statement occurs within the same transaction as the
> previous, until a rollback() or commit() is issued. This is the
> opposite of "autocommit", where each statement occurs in a distinct
> transaction.
Hi Mike,
Thanks for the clarifications. I figured out that the failure was the
problem, but didn't understand exactly why. So pg doesn't
automatically roll back the transaction, apparently.
Regards, Faheem.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
