Working with: SQLAlchemy 0.3.7 Postgresql 8.2 Python 2.4 On my Postgresql 8.2 database server I have a stored function, say calculateaverage(). When executed from the DBMS software, the stored function updates a database table.
>From my Python script, I am trying to call my stored function like this: result = select(["*"], from_obj=[func.myschema.calculateaverage()], engine=connection.engine).execute() (where, connection.engine returns a sqlalchemy.engine.base.Engine object (with the correct engine.url attribute). myschema is the database schema I am working on. ) 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. I tried to look into database user rights, but those are not the problem as I am using the same user both from the script and the DBMS. What else shall I investigate to solve this problem? Am I issuing a wrong SQLAlchemy statement? Thank you. --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
