[SQLObject] Forking & Postgres

[J-P L. <jp...@si...>]

Is anyone else having problems when forking multiple processes?

I'm using postgres and am getting the following error:

    File "ContactModel.py", line 42, in getContacts
    for contactDBO in resultList:
    File "SQLObject/DBConnection.py", line 134, in iterSelect
    OperationalError: ERROR: SET TRANSACTION ISOLATION LEVEL must be
    called before any query


I'm using cherrypy with SQLObject and simply setting forking=1 in the 
config which creates a new process with every request.

Search the net - people have pointed fingers at connection pooling.

Has anyone experienced a similiar problem or know more about this?

Thanks much!

--
J-P