Would you please post the traceback that you're getting with this?
Note that you don't need the session.begin() and session.flush() with a
transactional sessions, the .begin() is implicit and the .flush() will be
issued by the .commit()
On Tue, Apr 8, 2008 at 1:51 AM, Madhu Alagu <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
>
> I would like to use advantage of the Sqlalchemy & Stored Procedures.
>
>
> engine = create_engine('postgres://postgres:[EMAIL PROTECTED]:5432/
> neithal', echo=True)
> session =
> scoped_session(sessionmaker(bind=eng,transaction=True,autoflush=False))
> trans=session.begin()
> sql = select([func.add_user_f(108,'kk','kk')])
> result = session.execute(sql)
> result.close()
> session.flush()
> session.commit()
>
>
>
>
>
> Thanks
>
> Madhu Alagu
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
