On May 31, 2007, at 10:29 AM, Alchemist wrote:
> > No exceptions are raised when this statement is executed. HOWEVER, > the stored function does not seem to perform its required task as the > table that should be updated is not updated when running the script. > the stored procedure must be executed within an explcit transaction. SQLAlchemy always keeps the db connection with autocommit=False, and the reason statements like INSERT/UPDATE dont need an explicit transaction is because SA is calling commit() for you in the case of those statements. this is clearly a place I need to add a little helper feature, such as func.myfunc(x, y, z, transactional=True). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
