[sqlalchemy] Re: calling a stored function

2007-06-01 Thread Alchemist
@Michael Bayer Thank you. The issue could not be solved, probably due to database restrictions (e.g. allowing stored procedures to be used only by admin rights, even though SQLAlchemy used an admin type user...seems that the database server recognizes that the call is being made from an external

[sqlalchemy] calling a stored function

2007-05-31 Thread Alchemist
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

[sqlalchemy] how to retrieve/update data from/on multiple databases

2007-05-30 Thread Alchemist
Working with: Python 2.4 SQLAlchemy 0.3.7 Postgresql 8.2 database servers I am working in a multidatabase environment. I need to perform a query over multiple databases, then manipulate the obtained results and commit my changes in different tables in different databases. How can I query from

[sqlalchemy] stress tests / multithreading on SQLAlchemy 0.3.6

2007-05-28 Thread Alchemist
I developed my web application in TurboGears 1.0.1 (Python 2.4, CherryPy 2.2.1 and SQLAlchemy 0.3.6) and used Postgresql 8.2 as my backend. Also, I am using psycopg2. I am running stress tests (using tools such as WAPT and Web Application Stress Tool) to test the load supported by the web

[sqlalchemy] Re: stress tests / multithreading on SQLAlchemy 0.3.6

2007-05-28 Thread Alchemist
@Andreas Jung What SA configurations did you set/unset for your Zope application? Which SA files should I modify in order for SA to support multithreading and/or serial primary keys in postgresql database? Thanks Andreas Jung wrote: --On 27. Mai 2007 23:27:30 -0700 Alchemist [EMAIL

[sqlalchemy] Re: stress tests / multithreading on SQLAlchemy 0.3.6

2007-05-28 Thread Alchemist
@Andreas Jung Thanks. So the problems might be coming either from CherryPy (the TurboGears server/controller) or from Kid templates (TurboGears templates). Andreas Jung wrote: --On 27. Mai 2007 23:45:43 -0700 Alchemist [EMAIL PROTECTED] wrote: @Andreas Jung What SA configurations did